TAR_USAGE_HISTORY
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.
Columns
|
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
|
Table example
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