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.