Snowflake · Schema
ComputePool
A Snowflake compute pool definition.
Data LakesData SharingData WarehousingDatabaseSQL
Properties
| Name | Type | Description |
|---|---|---|
| min_nodes | integer | Minimum number of nodes for the compute pool. |
| max_nodes | integer | Maximum number of nodes for the compute pool. |
| instance_family | string | Instance family for the compute pool. |
| auto_resume | boolean | Whether Snowflake automatically resumes the compute pool when any statement that requires the compute pool is submitted. |
| comment | string | Comment describing the compute pool. |
| state | string | Current state of the compute pool. Possible values include UNKNOWN, STARTING, IDLE, ACTIVE, STOPPING, SUSPENDED, and RESIZING. |
| num_services | integer | Number of services on the compute pool. |
| num_jobs | integer | Number of jobs on the compute pool. |
| auto_suspend_secs | integer | Number of seconds until the compute pool automatically suspends. |
| active_nodes | integer | Number of currently active nodes on the compute pool. |
| idle_nodes | integer | Number of currently idle nodes on the compute pool. |
| target_nodes | integer | Number of target nodes on the compute pool. |
| created_on | string | Time the compute pool was created. |
| resumed_on | string | Time the compute pool was last resumed. |
| updated_on | string | Time the compute pool was last updated. |
| owner | string | Identifier for the current owner of the compute pool. |
| is_exclusive | boolean | Whether a compute pool is created exclusively for a Snowflake Native App. |
| application | string | Name of the Snowflake Native App if the compute pool is created exclusively for the app. |
| budget | string | The name of the budget monitoring the credit usage of the compute pool. |
| error_code | string | Current error the compute pool hit if any. |
| status_message | string | Current status of the compute pool if any. |