- 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, Data Transfer, 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, storage, or data transfer. |
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.
This view is accessible only by a user with the ORGADMIN role.