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.