- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
STORAGE_
Important
This view is only available in the organization account. For more information, see Premium views in the organization account.
Organization Usage performance
When you query a specific view in the SNOWFLAKE.ORGANIZATION_USAGE schema, follow the organization-wide guidance in
Performance (Organization Usage): bound every scan on history views, list
columns explicitly, and use the time filter column table plus worked SQL and anti-patterns there.
This Organization Usage view displays the average daily data storage usage, in bytes, for each account in your organization for the last 365 days (1 year). Each row is the storage for a single account on a given date, including data in:
- Database tables.
- Files in all internal stages.
Columns¶
Organization-level columns
| Column Name | Data Type | Description |
|---|---|---|
| ORGANIZATION_NAME | VARCHAR | Name of the organization. |
| ACCOUNT_LOCATOR | VARCHAR | System-generated identifier for the account. |
| ACCOUNT_NAME | VARCHAR | User-defined identifier for the account. |
Additional columns
| Column Name | Data Type | Description |
|---|---|---|
| USAGE_DATE | DATE | Date of this storage usage record. The date is based on the local time zone. It is recommended that you change the query session to use the UTC time zone instead (for example, ALTER SESSION SET TIMEZONE='UTC'). |
| STORAGE_BYTES | NUMBER | Number of bytes of table storage used, including bytes currently in Time Travel. |
| STAGE_BYTES | NUMBER | Number of bytes of stage storage used by files in all internal stages (named, table, and user). |
| FAILSAFE_BYTES | NUMBER | Number of bytes of Fail-safe storage used. |
| HYBRID_TABLE_STORAGE_BYTES | NUMBER | Number of bytes of hybrid table storage used (data in the row store). |
| ARCHIVE_STORAGE_COOL_BYTES | NUMBER | Number of all bytes of table storage used in the COOL storage tier, including active bytes, Fail-safe bytes, Time Travel bytes, and bytes subject to minimum storage duration charges. |
| ARCHIVE_STORAGE_COLD_BYTES | NUMBER | Number of all bytes of table storage used in the COLD storage tier, including active bytes, Fail-safe bytes, Time Travel bytes, and bytes subject to minimum storage duration charges. |
| ARCHIVE_STORAGE_RETRIEVAL_TEMP_BYTES | NUMBER | Number of bytes used in the standard storage tier, during data retrieval from the COLD storage tier. |
Usage notes¶
- Latency for the view may be up to 240 minutes (4 hours).
- This view uses a different measurement approach than the one used for billing, so the values here won’t match your invoice exactly. For the storage view that most closely reflects billed storage at the account and organization level, see STORAGE_DAILY_HISTORY view.