Schemas:

ACCOUNT_USAGE , READER_ACCOUNT_USAGE

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.

Usage Notes

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