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 (edition) of the Snowflake account (Standard, Enterprise, Business Critical, etc.).

USAGE_DATE

DATE

Date (in UTC format) in which the usage took place.

USAGE_TYPE

VARCHAR

Type of usage, which can be one of Compute, Storage, Data Transfer, Materialized Views, etc.

CURRENCY

VARCHAR

Currency of the usage.

USAGE

NUMBER (38,6)

Total number of credits charged for the USAGE_TYPE for usage on the USAGE_DATE. If the USAGE_TYPE is Data Transfer, the USAGE is TBs of data, not credits.

USAGE_IN_CURRENCY

NUMBER (38,6)

Total amount charged for the USAGE_TYPE for USAGE on the USAGE_DATE.

BALANCE_SOURCE

VARCHAR

Source of the funds used to pay for the daily usage. The source can be one of the following:

  • capacity — Usage paid with credits remaining on an organization’s capacity contract.

  • rollover — Usage paid with rollover credits. When an organization renews a capacity contract, unused credits are added to the balance of the new contract as rollover credits.

  • free usage — Usage covered by the free credits provided to the organization.

  • overage — Usage that was paid at on-demand pricing, which occurs when an organization has exhausted its capacity, rollover, and free credits.

  • rebate — Usage covered by the credits awarded to the organization when it shared data with another organization.

Usage Notes

  • Latency for the view may be up to 72 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.

  • Customers who signed a contract through a Snowflake reseller cannot access data in this view.

  • Data is retained indefinitely.

  • This view does not include data generated prior to June 2020. To obtain data before this date, contact Snowflake Support.