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. For each usage type, overage is prepended when the usage was billed at on-demand pricing because it exceeded the capacity of the contract. Possible usage types include:

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.