Documentation
Toggle Dark/Light/Auto modeToggle Dark/Light/Auto modeToggle Dark/Light/Auto modeBack to homepage

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’

anshul@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