DROP COMPUTE POOL

Removes the specified compute pool from the account.

See also:

CREATE COMPUTE POOL , ALTER COMPUTE POOL, DESCRIBE COMPUTE POOL , SHOW COMPUTE POOLS

语法

DROP COMPUTE POOL [ IF EXISTS ] <name>

参数

name

为要删除的计算池指定标识符。

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.

访问控制要求

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

权限对象备注
OWNERSHIP计算池

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.

使用说明

  • When dropping a compute pool, Snowflake automatically aborts any running jobs. However, Snowflake does not drop running services. If services are running this command will fail. You need to explicitly drop all running services before dropping a compute pool. You can run ALTER COMPUTE POOL … STOP ALL, which drops both services and jobs. You can also use the DROP SERVICE command to drop individual services.
  • When the IF EXISTS clause is specified and the target object doesn’t exist, the command completes successfully without returning an error.

示例

The following example drops the compute pool named tutorial_compute_pool:

DROP COMPUTE POOL tutorial_compute_pool;
+---------------------------------------------+
| status                                      |
%---------------------------------------------%
| TUTORIAL_COMPUTE_POOL successfully dropped. |
+---------------------------------------------+