Schema:

ORGANIZATION_USAGE

PREVIEW_METERING_DAILY_HISTORY View

The PREVIEW_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).

Note

The name of this view may change during the preview period or when the organizations feature is generally available.

Columns

Column Name

Data Type

Description

SERVICE_TYPE

VARCHAR

The type of service, which can be one of WAREHOUSE_METERING, WAREHOUSE_METERING_READER, AUTOMATIC_CLUSTERING, MATERIALIZED_VIEW, PIPE, or REPLICATION.

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

FLOAT

Number of credits used for compute/virtual warehouses during the USAGE_DATE.

CREDITS_USED_CLOUD_SERVICES

FLOAT

Number of credits used for cloud services during the USAGE_DATE.

CREDITS_USED

FLOAT

Total of CREDITS_USED_COMPUTE plus CREDITS_USED_CLOUD_SERVICES.

CREDITS_ADJUSTMENT_CLOUD_SERVICES

FLOAT

Number of credits adjusted for included cloud services. This is a negative value (e.g. -9).

CREDITS_BILLED

FLOAT

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).