- Schema:
For guidance on query performance when using organization-wide usage views, see Performance (Organization Usage).
COMPUTE_
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 a row for each compute pool across all the accounts in your organization, including compute pools that have been dropped.
- See also:
COMPUTE_POOLS view (Account Usage)
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 |
|---|---|---|
| NAME | VARCHAR | Compute pool name. |
| ID | NUMBER | Internal, Snowflake-generated identifier for the compute pool. |
| IS_SUSPENDED | BOOLEAN | Whether the pool is currently suspended. |
| MIN_NODES | NUMBER | Minimum number of nodes in the compute pool. |
| MAX_NODES | NUMBER | Maximum number of nodes in the compute pool. |
| INSTANCE_FAMILY | VARCHAR | Machine type of nodes in the compute pool. |
| AUTO_SUSPEND_SECS | NUMBER | Number of seconds of inactivity after which the compute pool is automatically suspended. |
| AUTO_RESUME | BOOLEAN | Whether the compute pool is automatically resumed when Snowflake attempts to start a service or job. |
| CREATED | TIMESTAMP_LTZ | Date and time when the compute pool was created. |
| LAST_RESUMED | TIMESTAMP_LTZ | Date and time when the suspended compute pool was last resumed. |
| LAST_ALTERED | TIMESTAMP_LTZ | Date and time when the compute pool was last updated. |
| DELETED | TIMESTAMP_LTZ | Date and time when the compute pool was deleted. |
| OWNER | VARCHAR | Role name that owns the compute pool. |
| OWNER_ROLE_TYPE | VARCHAR | Type of the role that owns the compute pool. |
| IS_EXCLUSIVE | BOOLEAN | Whether the compute pool was created for an application. |
| APPLICATION_NAME | VARCHAR | Application name for which the compute pool was created. Null if the compute pool was not created for an application or if the application no longer exists. |
| APPLICATION_ID | NUMBER | Application ID for which the compute pool was created. Null if the compute pool was not created for an application. |
| COMMENT | VARCHAR | A comment. |
Usage notes¶
- Latency for the view may be up to 24 hours.