DELETE_WAREHOUSE_POOL

Stored procedure DELETE_WAREHOUSE_POOL is a Snowflake stored procedure that is used to delete an existing warehouse pool object. This procedure is defined in database SUNDECK (database where Snowflake NativeApp is installed) schema ADMIN.

APP ADMIN privilege is required to run this stored procedure.

See also:: CREATE_WAREHOUSE_POOL, UPDATE_WAREHOUSE_POOL, LIST_WAREHOUSE_POOLS

Syntax

DELETE_WAREHOUSE_POOL(<name>)

Arguments

<name>: name of warehouse pool to delete.

Returns

NULL: if warehouse pool was successfully deleted.
<error>: error message string in the case of failure to delete warehouse pool.

Example:

Let’s delete warehouse pool named ‘AUTO_ROUTING_POOL’

coral@sundeck.io#COMPUTE_WH@OPSCENTER.ADMIN>call DELETE_WAREHOUSE_POOL('AUTO_ROUTING_POOL');
+-----------------------+                                                       
| DELETE_WAREHOUSE_POOL |
|-----------------------|
| NULL                  |
+-----------------------+
1 Row(s) produced. Time Elapsed: 13.994s