Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.snowflake.com/en/sql-reference/sql/alter-compute-pool below:

Website Navigation

• Reference
• SQL command reference
• Snowpark Container Services

ALTER COMPUTE POOL | Snowflake Documentation

Modifies the properties of an existing compute pool.

Tip

In addition to SQL, you can also use other interfaces, such as Snowflake REST APIs, Snowflake Python APIs, and Snowflake CLI. See Alternate interfaces.

See also:

CREATE COMPUTE POOL , DESCRIBE COMPUTE POOL, DROP COMPUTE POOL , SHOW COMPUTE POOLS

ALTER COMPUTE POOL [ IF EXISTS ] <name> { SUSPEND | RESUME }

ALTER COMPUTE POOL [ IF EXISTS ] <name> STOP ALL;

ALTER COMPUTE POOL [ IF EXISTS ] <name> SET [ MIN_NODES = <num> ]
                                            [ MAX_NODES = <num> ]
                                            [ AUTO_RESUME = { TRUE | FALSE } ]
                                            [ AUTO_SUSPEND_SECS = <num> ]
                                            [ COMMENT = '<string_literal>' ]
                                            [ TAG <tag_name> = '<tag_value>' [ , <tag_name> = '<tag_value>' , ... ] ]

ALTER COMPUTE POOL [ IF EXISTS ] <name> UNSET { AUTO_SUSPEND_SECS |
                                                AUTO_RESUME       |
                                                COMMENT
                                              }
                                              [ , ... ]

Copy

name

Specifies the identifier for the compute pool to alter.

If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

{ SUSPEND | RESUME }

Suspends a compute pool or resumes a previously suspended compute pool. When you suspend a compute pool, Snowflake suspends all services in that compute pool, but the jobs continue to run until they reach a terminal state (DONE or FAILED), after which the compute pool nodes are released.

STOP ALL

Drops all services and cancels jobs executing in the compute pool. Snowflake then removes all the containers from the compute pool.

SET ...

Sets one or more specified properties or parameters for the compute pool:

MIN_NODES = num

Specifies the minimum number of compute pool nodes.

MAX_NODES = num

Specifies the maximum number of compute pool nodes.

AUTO_RESUME = { TRUE | FALSE }

Specifies whether to automatically resume a compute pool when a service or job is submitted to it. If AUTO_RESUME is FALSE, you need to explicitly resume the compute pool (using ALTER COMPUTE POOL <name> RESUME) before you can start a service or job on the compute pool.

AUTO_SUSPEND_SECS = num

Number of seconds of inactivity after which you want Snowflake to automatically suspend the compute pool. Inactivity means no services and no jobs running on any node in the compute pool.

TAG tag_name = 'tag_value' [ , tag_name = 'tag_value' , ... ]

Specifies the tag name and the tag string value.

The tag value is always a string, and the maximum number of characters for the tag value is 256.

For information about specifying tags in a statement, see Tag quota for objects.

COMMENT = 'string_literal'

Specifies a comment for the compute pool.

UNSET ...

Specifies one (or more) properties and/or parameters to unset for the compute pool, which resets them to the defaults (see CREATE COMPUTE POOL):

• AUTO_SUSPEND_SECS

• AUTO_RESUME

• COMMENT

A role used to execute this operation must have the following privileges at a minimum:

Privilege

Object

Notes

OPERATE

Compute pool

To suspend or resume a compute pool, the role requires these permissions.

MODIFY

Compute pool

To alter the compute pool and set properties, the role requires this permission.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

• Regarding metadata:

  Attention

  Customers should ensure that no personal data (other than for a User object), sensitive data, export-controlled data, or other regulated data is entered as metadata when using the Snowflake service. For more information, see Metadata fields in Snowflake.

The following example sets the MAX_NODES and AUTO_RESUME properties for a compute pool:

ALTER COMPUTE POOL tutorial_compute_pool SET
  MAX_NODES = 5
  AUTO_RESUME = FALSE

Copy

• Snowflake REST APIs

  • Create a (or alter an existing) compute pool.

  • Suspend an active compute pool.

  • Resume a suspended compute pool.

  • Stop all services on the compute pool.

• Snowflake Python APIs

  • compute_pool.ComputePoolResource.create_or_alter method

• Snowflake CLI

  • Not supported

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4