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