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 a specified date range. The output will include storage for:

  • Named internal stages.

  • Default staging areas (for tables and users).

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 of this storage usage record.

AVERAGE_STAGE_BYTES

NUMBER

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