- Schemas:
METERING_HISTORY View¶
The METERING_HISTORY view in the ACCOUNT_USAGE schema can be used to return the hourly credit usage for an account within the last 365 days (1 year).
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
ACCOUNT_NAME |
TEXT |
Name of the account where the usage took place. |
SERVICE_TYPE |
TEXT |
The type of service, which can be one of |
START_TIME |
TIMESTAMP_LTZ |
The date and beginning of the hour (in the UTC time zone) in which the usage took place. |
END_TIME |
TIMESTAMP_LTZ |
The date and end of the hour (in the UTC time zone) in which the usage took place. |
ENTITY_ID |
NUMBER |
Internal/system-generated identifier for the service type. |
NAME |
TEXT |
Name of the service type. |
CREDITS_USED_COMPUTE |
NUMBER |
Number of credits used for virtual warehouses in the hour. |
CREDITS_USED_CLOUD_SERVICES |
NUMBER |
Number of credits used for cloud services in the hour. |
CREDITS_USED |
NUMBER |
Total number of credits used for the account in the hour. This is a sum of CREDITS_USED_COMPUTE and CREDITS_USED_CLOUD_SERVICES. This value does not take into account the adjustement for cloud services, and may therefore be greater than your actual credit consumption. |
BYTES |
NUMBER |
If the service type is |
ROWS |
NUMBER |
When the service type is |
Usage Notes¶
Latency for the view may be up to 180 minutes (3 hours).