Schemas:

ACCOUNT_USAGE , READER_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

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.

USAGE_DATE

TIMESTAMP_LTZ

The date (in the UTC time zone) in which the usage took place.

CREDITS_USED_COMPUTE

NUMBER

Number of credits billed for virtual warehouses in the hour.

CREDITS_USED_CLOUD_SERVICES

NUMBER

Number of credits billed for cloud services in the hour.

CREDITS_ADJUSTEMENT_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_ADJUSTEMENT_CLOUD_SERVICES.

Usage Notes

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