Schema:: ORGANIZATION_USAGE

DATABASE_STORAGE_USAGE_HISTORY view¶

The DATABASE_STORAGE_USAGE_HISTORY view in the ORGANIZATION_USAGE schema can be used to query the average daily storage usage, in bytes, for all the databases in your organization within a specified date range. The results include:

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

Columns¶

Column Name	Data Type	Description
ORGANIZATION_NAME	VARCHAR	Name of the organization where the usage took place.
ACCOUNT_NAME	VARCHAR	Name of the account where the usage took place.
ACCOUNT_LOCATOR	VARCHAR	Name of the account locator.
REGION	VARCHAR	Name of the region where the account is located.
USAGE_DATE	DATE	Date (in the UTC time zone) of this storage usage record.
DATABASE_NAME	VARCHAR	Name of the database.
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.
DATABASE_ID	NUMBER	Internal/system-generated identifier for the database.
DELETED	TIMESTAMP_LTZ	Date and time when the database was dropped; NULL for active databases.
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 24 hours (1 day).

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');