Total Active Rows (TAR) is the total count of rows made available from Zuora to your Snowflake account in your secure data share. You can use the
TAR_USAGE_HISTORY table to monitor the TAR usage of your Snowflake account.
Zuora updates the
TAR_USAGE_HISTORY table on a daily basis. Each row in this table represents the TAR usage record of a specific Zuora business object.
Zuora does not charge for rows used by the TAR_USAGE_HISTORY table in your secure data share. As such, the TAR_USAGE_HISTORY table does not include row counts from this table itself, whereas soft deleted records of Zuora business objects are included.
|Column name||Data type||Description|
|TENANT_ID||VARCHAR||ID of your Zuora tenant who owns the object that this TAR usage record was created for.|
|USAGE_DATE||DATE||Valid date of the TAR usage value of this record.|
|CREATED_ON||TIMESTAMP_TZ||Date and time when this TAR usage record was created.|
|TOTAL_ACTIVE_ROWS||NUMBER||TAR usage value of the Zuora business object.|
|VIEW_NAME||VARCHAR||View name of the Zuora business object in Snowflake.|
|SECURE_SHARE_NAME||VARCHAR||The shared database name, in the format of
The following is an example of the
TAR_USAGE_HISTORY table with TAR usage records for the Account, Invoice and Payment objects:
TENANT_ID,USAGE_DATE,CREATED_ON,TOTAL_ACTIVE_ROWS,VIEW_NAME,SECURE_SHARE_NAME 33456,2023-08-15,2023-08-15T00:33:42.936Z,8507,ACCOUNT,ZUORA_33456 33456,2023-08-15,2023-08-15T00:33:42.936Z,28936,INVOICE,ZUORA_33456 33456,2023-08-15,2023-08-15T00:33:42.936Z,91200,PAYMENT,ZUORA_33456