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 ZUORA_<tenant ID>. |
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