Schema:

BILLING

PARTNER_USAGE_IN_CURRENCY_DAILY view

The PARTNER_USAGE_IN_CURRENCY_DAILY view in the BILLING schema provides the daily credit usage and daily currency usage for all of a reseller’s customers.

Columns

Column NameData TypeDescription
ORGANIZATION_NAMEVARCHARName of the reseller’s organization.
SOLD_TO_ORGANIZATION_NAMEVARCHARName of the organization of the reseller’s customer.
SOLD_TO_CUSTOMER_NAMEVARCHARName of the reseller’s customer.
SOLD_TO_PO_NUMBERVARCHARPurchase order number associated with the reseller’s sale to the customer (if available).
SOLD_TO_CONTRACT_NUMBERVARCHARNumber associated with the customer’s contract with the reseller.
ACCOUNT_NAMEVARCHARName of the account where the usage was consumed.
ACCOUNT_LOCATORVARCHARLocator for the account where the usage was consumed. The locator is used in the legacy account identifier.
REGIONVARCHARName of the region where the account is located.
SERVICE_LEVELVARCHARService level of the Snowflake account (Standard, Enterprise, Business Critical, etc.).
USAGE_DATEDATEDate (in UTC) in which the usage took place.
USAGE_TYPEVARCHAR

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:

CURRENCYVARCHARCurrency associated with the usage.
USAGENUMBER (38,6)Total number of credits charged for the USAGE_TYPE for usage on the USAGE_DATE.
USAGE_IN_CURRENCYNUMBER (38,6)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. 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 of the reseller’s customer 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 can 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, contract amendments, or Snowflake account transfers between organizations.

Example query

To query the usage in credits and currency for all Snowflake accounts under your customers’ organizations for the month of January 2022:

SELECT * FROM snowflake.billing.partner_usage_in_currency_daily
  WHERE MONTH(usage_date) = 01
    AND YEAR(usage_date) = 2022
  ORDER BY sold_to_contract_number, usage_date ASC;