Titan Core
  • Overview
  • Getting Started
  • Working With Resources
  • Blueprint
  • GitHub Action
  • Resources
    • APIAuthenticationSecurityIntegration
    • APIIntegration
    • AccountParameter
    • AggregationPolicy
    • Alert
    • AuthenticationPolicy
    • AzureStorageIntegration
    • ComputePool
    • Database
    • DatabaseRole
    • DynamicTable
    • EmailNotificationIntegration
    • EventTable
    • ExternalAccessIntegration
    • ExternalStage
    • FailoverGroup
    • FutureGrant
    • GCSStorageIntegration
    • GenericSecret
    • GlueCatalogIntegration
    • Grant
    • GrantOnAll
    • HybridTable
    • ImageRepository
    • InternalStage
    • JSONFileFormat
    • JavascriptUDF
    • MaterializedView
    • NetworkPolicy
    • NetworkRule
    • OAuthSecret
    • ObjectStoreCatalogIntegration
    • PackagesPolicy
    • ParquetFileFormat
    • PasswordPolicy
    • PasswordSecret
    • Pipe
    • PythonStoredProcedure
    • PythonUDF
    • ReplicationGroup
    • ResourceMonitor
    • Role
    • RoleGrant
    • S3StorageIntegration
    • Schema
    • Sequence
    • Service
    • SessionPolicy
    • Share
    • SnowflakePartnerOAuthSecurityIntegration
    • SnowservicesOAuthSecurityIntegration
    • StageStream
    • Table
    • TableStream
    • Tag
    • Task
    • User
    • View
    • ViewStream
    • Warehouse
Powered by GitBook
On this page
  • Examples
  • Python
  • YAML
  • Fields
  1. Resources

ComputePool

PreviousAzureStorageIntegrationNextDatabase

Last updated 10 months ago

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.

  • min_nodes (int) - The minimum number of nodes in the compute pool.

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

  • 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.

owner (string or ) - The owner of the compute pool. Defaults to "ACCOUNTADMIN".

instance_family (string or ) - The family of instances to use for the compute nodes.

Snowflake Documentation
Role
InstanceFamily