- Schema:
RATE_SHEET_DAILY View¶
The RATE_SHEET_DAILY view in the ORGANIZATION_USAGE schema returns the effective rates used for calculating usage in the organization currency based on credits used for all Snowflake accounts in your organization.
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
DATE |
DATE |
Date (in the UTC time zone) for the effective price. |
ORGANIZATION_NAME |
VARCHAR |
Name of the organization. |
CONTRACT_NUMBER |
VARCHAR |
Snowflake contract number for the organization. |
ACCOUNT_NAME |
VARCHAR |
Name of the account. |
ACOUNT_LOCATOR |
VARCHAR |
Locator for the account. |
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_TYPE |
VARCHAR |
The type of usage, which can be one of Compute, Storage, Materialized Views, etc. |
CURRENCY |
VARCHAR |
The currency of the EFFECTIVE_RATE. |
EFFECTIVE_RATE |
NUMBER(38, 2) |
The rate after applying any applicable discounts per the contract for the organization. |
SERVICE_TYPE |
VARCHAR |
The type of service, which can be one of compute or storage. |
Usage Notes¶
Latency for the view may be up to 24 hours.
Until month close, data for a given day in a month can change to account for any end-of-month adjustments/credits, mid-month contract amendments, or Snowflake account transfers from one organization to another.
Customers who signed a contract through a Snowflake reseller cannot access data in this view.
This view does not include data generated prior to June 2020. To obtain data before this date, contact Snowflake Support.
Only users with the ORGADMIN or ACCOUNTADMIN role can access this view.