Schema:

ORGANIZATION_USAGE

STAGE_STORAGE_USAGE_HISTORY view

The STAGE_STORAGE_USAGE_HISTORY view in the ORGANIZATION_USAGE schema can be used to query the average daily data storage usage, in bytes, for all the Snowflake stages in your organization within the last 12 months.

The output includes storage for:

  • Named internal stages.
  • Default staging areas (for tables and users).

Columns

Column NameData TypeDescription
ORGANIZATION_NAMEVARCHARName of the organization where the usage took place.
ACCOUNT_NAMEVARCHARName of the account where the usage took place.
ACCOUNT_LOCATORVARCHARName of the account locator.
REGIONVARCHARName of the region where the account is located.
USAGE_DATEDATEDate of this storage usage record.
AVERAGE_STAGE_BYTESNUMBERNumber of bytes of stage 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).