This provides a list ofcompute_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 |
+-------+-----------------+---------------+-----------------+----------------+-------+----------+-------------+------------+-----------------------------------+----------------------------------+
