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 `warehouse_metering`, `warehouse_metering_reader`, `automatic_clustering`, `materialized_view`, `pipe`, or `replication`.
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 `auto_clustering`, indicates the number of bytes reclustered during the START_TIME and END_TIME window. If the service type is `pipe`, indicates the number of bytes inserted during the START_TIME and END_TIME window.
ROWS	NUMBER	When the service type is `auto_clustering`, indicates number of rows reclustered during the START_TIME and END_TIME window.