ComputePool

Snowflake Documentation

A compute pool is a group of compute resources in Snowflake that can be used to execute SQL queries.

Examples

Python

compute_pool = ComputePool(
    name="some_compute_pool",
    owner="ACCOUNTADMIN",
    min_nodes=2,
    max_nodes=10,
    instance_family="CPU_X64_S",
    auto_resume=True,
    initially_suspended=False,
    auto_suspend_secs=1800,
    comment="Example compute pool"
)

YAML

compute_pools:
  - name: some_compute_pool
    owner: ACCOUNTADMIN
    min_nodes: 2
    max_nodes: 10
    instance_family: CPU_X64_S
    auto_resume: true
    initially_suspended: false
    auto_suspend_secs: 1800
    comment: Example compute pool

Fields

• name (string, required) - The unique name of the compute pool.

• owner (string or Role) - The owner of the compute pool. Defaults to "ACCOUNTADMIN".
• min_nodes (int) - The minimum number of nodes in the compute pool.

• max_nodes (int) - The maximum number of nodes in the compute pool.

• instance_family (string or InstanceFamily) - The family of instances to use for the compute nodes.
• auto_resume (bool) - Whether the compute pool should automatically resume when queries are submitted. Defaults to True.

• initially_suspended (bool) - Whether the compute pool should start in a suspended state.

• auto_suspend_secs (int) - The number of seconds of inactivity after which the compute pool should automatically suspend. Defaults to 3600.

• comment (string) - An optional comment about the compute pool.