- Schema:
STORAGE_DAILY_HISTORY view¶
The STORAGE_DAILY_HISTORY view in the ORGANIZATION_USAGE schema can be used to query the average daily storage usage, in bytes, for all accounts in the organization for the last 365 days (1 year).
Columns¶
Column Name |
Data Type |
Description |
|---|---|---|
SERVICE_TYPE |
VARCHAR |
The type of service, which can be one of |
ACCOUNT_LOCATOR |
VARCHAR |
Locator for the account where the usage took place. |
ORGANIZATION_NAME |
VARCHAR |
Name of the organization where the usage took place. |
ACCOUNT_NAME |
VARCHAR |
Name of the account where the usage took place. |
USAGE_DATE |
DATE |
The date (in the UTC time zone) on which the usage took place. |
AVERAGE_BYTES |
NUMBER |
Average number of bytes of database storage and stage storage used on this date, including data in Time Travel and Fail-safe. |
REGION |
VARCHAR |
ID of the Snowflake Region where the account is located. |
CREDITS |
NUMBER |
Total number of credits used for all accounts in the organization on this date. This is the sum of the credits used for database storage and stages (e.g. data in Time Travel, Fail-safe, internal stages, etc.) |
Usage notes¶
Latency for the view may be up to 120 minutes (2 hours).
The data is retained for 365 days (1 year).