Skip to navigation
IntegrationIntegration HubZuora Secure Data Share for SnowflakeTables for monitoring

TAR_USAGE_HISTORY

View as Markdown

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

The following table provides information on columns:

Column nameData typeDescription
TENANT_IDVARCHARID of your Zuora tenant who owns the object that this TAR usage record was created for.
USAGE_DATEDATEValid date of the TAR usage value of this record.
CREATED_ONTIMESTAMP_TZDate and time when this TAR usage record was created.
TOTAL_ACTIVE_ROWSNUMBERTAR usage value of the Zuora business object.
VIEW_NAMEVARCHARView name of the Zuora business object in Snowflake.
SECURE_SHARE_NAMEVARCHARThe 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