Schema:: ACCOUNT_USAGE

DATABASE_STORAGE_USAGE_HISTORY view¶

This Account Usage view can be used to query the average daily storage usage, in bytes, for databases in the account for the last 365 days (1 year). The data includes:

All data stored in tables in the database(s).
All historical data maintained in Fail-safe for the database(s).

See also:: STORAGE_DAILY_HISTORY view , STORAGE_USAGE view , TABLE_STORAGE_METRICS view

Note

This view isn’t designed to reconcile with your Snowflake bill. As a result, the sum of database-level usage in this view won’t equal the billed storage for your account.

For a view that more closely reflects billed storage at the account and organization level, see STORAGE_DAILY_HISTORY view.

Columns¶


Column Name	Data Type	Description
USAGE_DATE	DATE	Date (in the local time zone) of this storage usage record. It is recommended that you change the query session to use the UTC time zone instead (e.g. `ALTER SESSION SET TIMEZONE='UTC'`).
DATABASE_ID	NUMBER	Internal/system-generated identifier for the database.
DATABASE_NAME	VARCHAR	Name of the database.
DELETED	TIMESTAMP_LTZ	Date and time when the database was dropped; NULL for active databases.
AVERAGE_DATABASE_BYTES	FLOAT	Number of bytes of database storage used, including bytes currently in Time Travel.
AVERAGE_FAILSAFE_BYTES	FLOAT	Number of bytes of Fail-safe storage used.
AVERAGE_HYBRID_TABLE_STORAGE_BYTES	FLOAT	Number of bytes of hybrid table storage used (data in the row store).
AVERAGE_ARCHIVE_STORAGE_COOL_BYTES	FLOAT	Average number of bytes (including active bytes, time travel bytes, and bytes subject to minimum storage duration charges) of table storage used in the COOL storage tier.
AVERAGE_ARCHIVE_STORAGE_COLD_BYTES	FLOAT	Average number of bytes (including active bytes, time travel bytes, and bytes subject to minimum storage duration charges) of table storage used in the COLD storage tier.
AVERAGE_COOL_FAILSAFE_BYTES	FLOAT	Average number of bytes of Fail-safe storage used in the COOL storage tier.
AVERAGE_COLD_FAILSAFE_BYTES	FLOAT	Average number of bytes of Fail-safe storage used in the COLD storage tier.

Usage notes¶

Latency for the view may be up to 180 minutes (3 hours).
This view is suitable for comparing relative storage usage between databases in an account over time. It isn’t suitable for calculating exact database-level storage charges.
To approximate database-level storage costs for chargeback, combine each database’s share of usage in this view with your total billed storage from STORAGE_DAILY_HISTORY view or your invoice. Treat the result as an approximation, not an exact billing figure.
Note

With BCR-2127, this view includes new columns for storage lifecycle policies. To view storage lifecycle policy columns, you must enable the 2025_07 behavior change bundle in your account.

To enable this bundle in your account, execute the following statement:
SELECT SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE('2025_07');