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

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

Back to top