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	Type of service that is consuming credits, which can be one of the following: `AUTO_CLUSTERING` — Refer to Automatic Clustering. `MATERIALIZED_VIEW` — Refer to Working with Materialized Views. `PIPE` — Refer to Snowpipe. `QUERY_ACCELERATION` — Refer to Using the Query Acceleration Service. `REPLICATION` — Refer to Introduction to Replication and Failover. `SEARCH_OPTIMIZATION` — Refer to Using the Search Optimization Service. `SERVERLESS_TASK` — Refer to Introduction to Tasks. `SNOWPIPE_STREAMING` — Refer to Snowpipe Streaming. `WAREHOUSE_METERING` — Refer to Overview of Warehouses. `WAREHOUSE_METERING_READER` — Refer to Managing Reader Accounts.
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).

Language: English