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.
ACOUNT_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 type of usage, which can be one of Compute, Storage, Data Transfer, Materialized Views, etc.
USAGE_TYPE	VARCHAR	The amount for the CONTRACT_ITEM.
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.