- Schema:
METERING_DAILY_HISTORY View¶
The METERING_DAILY_HISTORY view in the ORGANIZATION_USAGE schema can be used to return the daily credit usage and a cloud services rebate for an organization within the last 365 days (1 year).
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
SERVICE_TYPE |
VARCHAR |
Type of service that is consuming credits, which can be one of the following:
|
ORGANIZATION_NAME |
VARCHAR |
Name of the organization where the usage took place. |
ACCOUNT_NAME |
VARCHAR |
Name of the account where the usage took place. |
ACCOUNT_LOCATOR |
VARCHAR |
Locator for the account where the usage took place. |
USAGE_DATE |
DATE |
The date (in the UTC time zone) in which the usage took place. |
CREDITS_USED_COMPUTE |
NUMBER |
Number of credits used for warehouses and serverless compute resources during the USAGE_DATE. |
CREDITS_USED_CLOUD_SERVICES |
NUMBER |
Number of credits used for cloud services during the USAGE_DATE. |
CREDITS_USED |
NUMBER |
Total of CREDITS_USED_COMPUTE plus 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. |
REGION |
VARCHAR |
ID of the Snowflake Region where the account is located. |
Usage Notes¶
Latency for the view may be up to 120 minutes (2 hours).
The data is retained for 365 days (1 year).