LIST_WAREHOUSE_POOLS

View WAREHOUSE_POOLS is a Snowflake view that is used to list existing warehouse pools. This procedure is defined in database SUNDECK (database where Snowflake NativeApp is installed) schema CATALOG.

APP ADMIN privilege is required to run this stored procedure.

See also:: CREATE_WAREHOUSE_POOL, UPDATE_WAREHOUSE_POOLS, DELETE_WAREHOUSE_POOL

Syntax

SELECT <COLUMNS> from CATALOG.WAREHOUSE_POOLS where <condition>

Returns

LIST of warehouse pools: each row contains a warehouse pool.

Example:

Let’s get warehouse pool named ‘AUTO_ROUTING_POOL’

ube@sundeck.io#COMPUTE_WH@OPSCENTER.ADMIN>select name,max_concurrent_credits,allowed_roles,default_warehouse_size,targe
                                             t_label from CATALOG.WAREHOUSE_POOLS where name = 'AUTO_ROUTING_POOL';
+-------------------+------------------------+---------------+------------------------+--------------+
| NAME              | MAX_CONCURRENT_CREDITS | ALLOWED_ROLES | DEFAULT_WAREHOUSE_SIZE | TARGET_LABEL |
|-------------------+------------------------+---------------+------------------------+--------------|
| AUTO_ROUTING_POOL |                      3 | [             | X-Small                | Writes       |
|                   |                        |   "CS_TEST1"  |                        |              |
|                   |                        | ]             |                        |              |
+-------------------+------------------------+---------------+------------------------+--------------+
1 Row(s) produced. Time Elapsed: 0.878s