Schema:

ORGANIZATION_USAGE

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.