Schema:: ORGANIZATION_USAGE

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 24 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.
This view is accessible only by a user with the ORGADMIN role.