DROP RESOURCE POOL

DROP RESOURCE POOL removes a resource pool.

Syntax

DROP RESOURCE POOL <name>

Parameters

  • name — name of the resource pool to drop.

Permissions

The REMOVE SCHEMA permission on the pool under .metadata/workload_manager/pools is required. Example:

GRANT 'REMOVE SCHEMA' ON `.metadata/workload_manager/pools` TO `user1@domain`;

Examples

The following removes the resource pool named olap:

DROP RESOURCE POOL olap;

See also