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

Corresponds 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.

USAGE

NUMBER (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.

CURRENCY

VARCHAR

Currency of the usage.

USAGE_IN_CURRENCY

NUMBER (38,2)

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 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_TYPE

VARCHAR

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_TYPE

VARCHAR

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

  • compute

  • data_transfer

  • storage

  • other

SERVICE_TYPE

VARCHAR

Type of usage. Possible service types include:

IS_ADJUSTMENT

BOOLEAN

Indicates 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.