Schema:

ACCOUNT_USAGE

METERING_DAILY_HISTORY View

The METERING_DAILY_HISTORY view in the ACCOUNT_USAGE schema can be used to return the daily credit usage and a cloud services rebate for an account within the last 365 days (1 year).

Columns

Column Name	Data Type	Description
SERVICE_TYPE	TEXT	The type of service, which can be one of AUTO_CLUSTERING, MATERIALIZED_VIEW, PIPE, QUERY_ACCELERATION 1, REPLICATION, SEARCH_OPTIMIZATION, WAREHOUSE_METERING, or WAREHOUSE_METERING_READER.
USAGE_DATE	TIMESTAMP_LTZ	The date (in the local time zone) in which the usage took place.
CREDITS_USED_COMPUTE	NUMBER	Number of credits billed for virtual warehouses in the day.
CREDITS_USED_CLOUD_SERVICES	NUMBER	Number of credits billed for cloud services in the day.
CREDITS_USED	NUMBER	Sum of CREDITS_USED_COMPUTE and CREDITS_USED_CLOUD_SERVICES.
CREDITS_ADJUSTMENT_CLOUD_SERVICES	NUMBER	Number of credits adjusted for included cloud services. This is a negative value (e.g. -9).
CREDITS_BILLED	NUMBER	Total number of credits billed for the account in the day. This is a sum of CREDITS_USED_COMPUTE, CREDITS_USED_CLOUD_SERVICES, and CREDITS_ADJUSTMENT_CLOUD_SERVICES.

1

Query Acceleration Service is available for preview for all accounts that are Enterprise Edition (or higher).

Usage Notes

• Latency for the view may be up to 180 minutes (3 hours).