- 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 (edition) of the Snowflake account (Standard, Enterprise, Business Critical, etc.). |
USAGE_DATE |
DATE |
Date (in UTC format) in which the usage took place. |
USAGE_TYPE |
VARCHAR |
Type of usage. For each usage type,
|
CURRENCY |
VARCHAR |
Currency of the usage. |
USAGE |
NUMBER (38,6) |
Total number of credits charged for the USAGE_TYPE for usage on the USAGE_DATE. If the USAGE_TYPE is Data Transfer, the USAGE is TBs of data, not credits. |
USAGE_IN_CURRENCY |
NUMBER (38,6) |
Total amount charged for the USAGE_TYPE for USAGE on the USAGE_DATE. |
BALANCE_SOURCE |
VARCHAR |
Source of the funds used to pay for the daily usage. The source can be one of the following:
|
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.
Data is retained indefinitely.
This view does not include data generated prior to June 2020. To obtain data before this date, contact Snowflake Support.