Skip to main content

WAREHOUSE_METERING_HISTORY

Zuora

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

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