DESC COMPUTE POOL command: New columns in output and deprecation of SYSTEM$GET_COMPUTE_POOL_STATUS¶

Error code, if any, relevant to the STATUS_MESSAGE. Otherwise, this field is empty.

For example, when you resize a compute pool:

• If Snowflake encounters a capacity error (new nodes can’t be provisioned), Snowflake returns the error code 392507.

Note that the capacity error indicates the instance type you requested for your compute pool node is currently not available with the cloud provider. You can either wait for the capacity to become available or choose another instance type.

• If you have pending services (including job services) and Snowflake cannot scale up your compute pool, Snowflake returns the error code 392508.

Optional message about the status of the compute pool. For example:

• After creating a compute pool, if you run the DESC COMPUTE POOL command, the output might include the status message: “Compute pool is starting for last 1 minute”
• If Snowflake encounters a capacity error when provisioning a node, the output might include the status message: “Compute pool is starting for the last 3 minutes. We have observed CAPACITY_ERROR.”
• If you have pending services (including job services) and Snowflake can’t scale up your compute pool, the output might include the status message: “Compute Pool has reached the maximum node limit. Consider increasing max_nodes using the ALTER COMPUTE POOL command.”