Schema:

ORGANIZATION_USAGE

REMAINING_BALANCE_DAILY View

The REMAINING_BALANCE_DAILY view in the ORGANIZATION_USAGE schema can be used to return the daily remaining balance and on demand consumption daily for an organization.

Columns

Column Name

Data Type

Description

ORGANIZATION_NAME

VARCHAR

Name of the organization.

CONTRACT_NUMBER

VARCHAR

Contract number for the organization.

DATE

DATE

The date of the FREE_USAGE_BALANCE or CAPACITY_BALANCE in the UTC time zone.

CURRENCY

VARCHAR

The currency of the FREE_USAGE_BALANCE or CAPACITY_BALANCE or ON_DEMAND_CONSUMPTION_BALANCE.

FREE_USAGE_BALANCE

NUMBER (38,2)

The amount of free usage in currency that is available for use as of the date. This is the end of day balance.

CAPACITY_BALANCE

NUMBER (38,2)

The amount of capacity in currency that is available for use as of the date. This is the end of day balance.

ON_DEMAND_CONSUMPTION_BALANCE

NUMBER (38,2)

The amount of consumption at on demand prices that will be invoiced given that all the free usage and capacity balances have been exhausted. This is a negative value (e.g. -250) until the invoice is paid. This is the end of day balance.

ROLLOVER_BALANCE

NUMBER (38,2)

The amount of rollover balance in currency that is available for use at the end of the date. At the end of a contract term, it is calculated as sum(AMOUNT) from the CONTRACT_ITEMS view - sum(USAGE_IN_CURRENCY) from the USAGE_IN_CURRENCY_DAILY view.

Usage Notes

  • Latency for the view may be up to 24 hours.

  • On demand consumption balance resets after month close (typically on the 3rd or 4th day of the next month) after it is invoiced and paid.

  • Until month close, data for a given day in a month can change to account for any end-of-month adjustments/credits or contract amendments between Snowflake organizations.

  • This view is accessible only by a user with the ORGADMIN role.