This table function can be used to query the average daily storage usage, in bytes, for a single database (or all the databases in your account) 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).
This function returns storage usage within the last 6 months.
DATABASE_STORAGE_USAGE_HISTORY( [ DATE_RANGE_START => <constant_expr> ] [, DATE_RANGE_END => <constant_expr> ] [, DATABASE_NAME => '<string>' ] )
All the arguments are optional.
DATE_RANGE_START => constant_expr, .
DATE_RANGE_END => constant_expr
The date range, within the last 6 months, for which to retrieve database storage usage:
- If an end date is not specified, then CURRENT_DATE is used as the end of the range.
- If a start date is not specified, then
DATE_RANGE_ENDis used as the start of the range (i.e. the default is one day of storage usage).
If the range falls outside the last 6 months, an error is returned.
DATABASE_NAME => 'string'
The name of the database to retrieve storage usage history for. Note that the database name must be enclosed in single quotes. Also, if the database name contains any spaces, mixed-case characters, or special characters, the name must be double-quoted witin the single quotes (e.g.
If no database is specified, then data is returned for all the databases in your account.
- Returns results only for the ACCOUNTADMIN role or any role that has been explicitly granted the MONITOR USAGE global privilege.
- When calling an Information Schema table function, the session must have an INFORMATION_SCHEMA schema in use or the function name must be fully-qualified. For more details, see Information Schema.
The function returns the following columns:
|Column Name||Data Type||Description|
|USAGE_DATE||DATE||Date of this storage usage record|
|DATABASE_NAME||TEXT||Name of the database|
|AVERAGE_DATABASE_BYTES||NUMBER||Number of bytes of database storage used|
|AVERAGE_FAILSAFE_BYTES||NUMBER||Number of bytes of fail-safe storage used|
If a database has been dropped and its data retention period has passed (i.e. the database cannot be recovered using Time Travel), then the database name is reported as
id is an internally-generated identifier. This ID can be used to match entries across rows returned by the table function.
Retrieve average daily storage usage for the past 10 days, per database, for all databases in your account:
select * from table(information_schema.database_storage_usage_history(dateadd('days',-10,current_date()),current_date()));