- Schema:
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).