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