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 NameData TypeDescription
ORGANIZATION_NAMEVARCHARName of the organization.
CONTRACT_NUMBERVARCHARSnowflake contract number for the organization.
ACCOUNT_NAMEVARCHARName of the account where the usage was consumed.
ACCOUNT_LOCATORVARCHARLocator for the account where the usage was consumed.
REGIONVARCHARName of the region where the account is located.
SERVICE_LEVELVARCHARService level (edition) of the Snowflake account (Standard, Enterprise, Business Critical, etc.).
USAGE_DATEDATEDate (in UTC format) in which the usage took place.
USAGE_TYPEVARCHARCorresponds to the Usage Category column in a billing statement, which exists for backward compatibility only. Use the BILLING_TYPE, RATING_TYPE, SERVICE_TYPE, and IS_ADJUSTMENT columns for billing reconciliation.
USAGENUMBER (38,3)Total amount of usage charged based on SERVICE_TYPE. The unit of the USAGE depends on the RATING_TYPE. For example, when the RATING_TYPE is compute, USAGE is measured in credits. When the RATING_TYPE is data transfer or storage, the usage is rated in terabytes.
CURRENCYVARCHARCurrency of the usage.
USAGE_IN_CURRENCYNUMBER (38,2)Total amount charged for the USAGE_TYPE for USAGE on the USAGE_DATE.
BALANCE_SOURCEVARCHAR

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 commitment.
  • rollover — Usage paid with rollover credits. When an organization renews a capacity commitment, 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.
BILLING_TYPEVARCHAR

Indicates what is being charged or credited. Possible billing types include:

  • consumption — Usage associated with compute credits, storage costs, and data transfer costs.
  • rebate — Usage covered by the credits awarded to the organization when it shared data with another organization.
  • priority support — Charges for priority support services. This charge is associated with a stipulation in a contract, not with an account.
  • vps_deployment_fee — Charges for a Virtual Private Snowflake deployment.
  • support_credit — Snowflake Support credited the account to reverse charges attributed to an issue in Snowflake.
RATING_TYPEVARCHAR

Indicates how the usage in the record is rated, or priced. Possible values include:

  • compute
  • data_transfer
  • storage
  • other
SERVICE_TYPEVARCHAR

Type of usage. The following list includes many, but not all, of the possible service types:

IS_ADJUSTMENTBOOLEANIndicates whether the record is an adjustment to usage.

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.