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