- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
WAREHOUSE_
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 can be used to analyze the workload on your warehouse within a specified date range.
- See also:
Columns¶
Note
For the output columns of this view, the query load value is the ratio of the total execution time (in seconds) of all queries in a specific state in an interval by the total time (in seconds) for that interval.
For example, if 276 seconds was the total time for 4 queries in a 5 minute (300 second) interval, then the query load value is 276 / 300 = 0.92.
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 |
|---|---|---|
| START_TIME | TIMESTAMP_LTZ | The start of the specified time range (in the UTC time zone) in which the warehouse usage took place. |
| END_TIME | TIMESTAMP_LTZ | The end of the specified time range (in the UTC time zone) in which the warehouse usage took place. |
| WAREHOUSE_ID | NUMBER | Internal/system-generated identifier for the warehouse. |
| WAREHOUSE_NAME | VARCHAR | Name of the warehouse. |
| AVG_RUNNING | NUMBER(38,9) | Query load value for queries executed. |
| AVG_QUEUED_LOAD | NUMBER(38,9) | Query load value for queries queued because the warehouse was overloaded. |
| AVG_QUEUED_PROVISIONING | NUMBER(38,9) | Query load value for queries queued because the warehouse was being provisioned. |
| AVG_BLOCKED | NUMBER(38,9) | Query load value for queries blocked by a transaction lock. |
Usage notes¶
- Latency for the view may be up to 24 hours.
- Load history is shown in 5-minute intervals.