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

While the feature is in preview, we may make some behavior changes. We will notify you about any changes before implementing them.

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.

Usage Notes

  • Latency for the view may be up to 24 hours (1 day).

  • The data is retained for 365 days (1 year).

Back to top