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