Schema:

ORGANIZATION_USAGE

# 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

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.

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.

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.

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 120 minutes (2 hours).

• The data is retained for 365 days (1 year).