- Schema:
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).
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. |
DATABASE_ID |
NUMBER |
Internal/system-generated identifier for the database. |
DATABASE_NAME |
TEXT |
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 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 180 minutes (3 hours).