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	TEXT	Name of the account where the usage took place.
ACCOUNT_LOCATOR	TEXT	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	TEXT	Name of the database.
AVERAGE_DATABASE_BYTES	FLOAT	Number of bytes of database storage used, including data 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 storage used.

Usage notes¶

Latency for the view may be up to 24 hours (1 day).
The data is retained for 365 days (1 year).