WAREHOUSE_METERING_HISTORY

The WAREHOUSE_METERING_HISTORY table stores the compute credit usage of your Zuora Warehouse . Each row in this table represents an hourly compute credit usage.

The warehouse size determines how many credits it consumes. A warehouse of X-Small size consumes 15 credits per hour (0.0042 credits per second).

Columns

The following table provides information on columns:

Column name	Data type	Description
TENANT_ID	VARCHAR	ID of your Zuora tenant that this compute credit usage relates to.
START_TIME	TIMESTAMP_TZ	The date and beginning of the hour when this compute credit usage occurred.
END_TIME	TIMESTAMP_TZ	The date and end of the hour when this compute credit usage occurred.
WAREHOUSE_SIZE	VARCHAR	Size of the warehouse where this compute credit usage occurred.
CREDITS_USED	NUMBER	Used credits during this hour.

Table example

The following is an example of the WAREHOUSE_METERING_HISTORY table with two compute credit usages whose used credits are 0.074588611 and 0.032626921:

TENANT_ID,START_TIME,END_TIME,WAREHOUSE_SIZE,CREDITS_USED
33456,2023-08-15T03:00:00Z,2023-08-15T04:00:00Z,X-Small,0.074588611
33456,2023-08-15T04:00:00Z,2023-08-15T05:00:00Z,X-Small,0.032626921