TAR_USAGE_HISTORY

Total Active Rows (TAR) is the total count of rows stored in the Zuora Warehouse and is one of the measures by which your usage of the Zuora Warehouse is charged.

You can use the TAR_USAGE_HISTORY table to monitor the TAR usage of Zuora Warehouse in your tenant.

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 the Zuora Warehouse. 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 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.
TABLE_NAME	VARCHAR	Name of the Zuora business object.

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,TABLE_NAME
33456,2023-08-15,2023-08-15T00:33:42.936Z,8507,ACCOUNT
33456,2023-08-15,2023-08-15T00:33:42.936Z,28936,INVOICE
33456,2023-08-15,2023-08-15T00:33:42.936Z,91200,PAYMENT