LIST COMPUTE_POOLS

Syntax

[LIST | SHOW] COMPUTE_POOLS;

Description

This provides a list of compute_pools to which you have access.

Important You're only able to list compute_pools if your current role has USAGE privileges.

Example

mydb.public/mystore# show COMPUTE_POOLS;
+-------+-----------------+---------------+-----------------+----------------+-------+----------+-------------+------------+-----------------------------------+----------------------------------+
|  Name |  Intended State |  Actual State |  Error Messages |  Access Region |  Size |  Timeout |  Is Default |    Owner   |             Created At            |            Updated At            |
+-------+-----------------+---------------+-----------------+----------------+-------+----------+-------------+------------+-----------------------------------+----------------------------------+
| "abc" | stopped         | stopped       |                 | K3D us-east-1  | small |      120 | true        | "sysadmin" | 2025-02-25 15:13:03.935 +0000 UTC | 2025-03-04 03:04:04.34 +0000 UTC |
+-------+-----------------+---------------+-----------------+----------------+-------+----------+-------------+------------+-----------------------------------+----------------------------------+