- Schema:
USAGE_IN_CURRENCY_DAILY View¶
The USAGE_IN_CURRENCY_DAILY view in the ORGANIZATION_USAGE schema can be used to return the daily credit usage and usage in currency for an organization.
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
ORGANIZATION_NAME |
VARCHAR |
Name of the organization. |
CONTRACT_NUMBER |
VARCHAR |
Snowflake contract number for the organization. |
ACCOUNT_NAME |
VARCHAR |
Name of the account where the usage was consumed. |
ACCOUNT_LOCATOR |
VARCHAR |
Locator for the account where the usage was consumed. |
REGION |
VARCHAR |
Name of the region where the account is located. |
SERVICE_LEVEL |
VARCHAR |
Service level of the Snowflake account (Standard, Enterprise, Business Critical, etc.). |
USAGE_DATE |
DATE |
The date (in the UTC time zone) in which the usage took place. |
USAGE_TYPE |
VARCHAR |
The type of usage, which can be one of Compute, Storage, Data Transfer, Materialized Views, etc. |
CURRENCY |
VARCHAR |
The currency of the usage. |
USAGE |
NUMBER (38,6) |
Total number of credits charged for the USAGE_TYPE for usage on the USAGE_DATE. |
USAGE_IN_CURRENCY |
NUMBER (38,6) |
Total amount charged for the USAGE_TYPE for USAGE on the USAGE_DATE. |
Usage Notes¶
Latency for the view may be up to 72 hours.
Until month close, data for a given day in a month can change to account for any end-of-month adjustments/credits, contract amendments, or Snowflake account transfers between organizations.
Customers who signed a contract through a Snowflake reseller cannot access data in this view.
This view is accessible only by a user with the ORGADMIN role.