SHOW COMPUTE POOL INSTANCE FAMILIES

Lists the available compute pool instance families that you can use to create a compute pool.

See also:

CREATE COMPUTE POOL , ALTER COMPUTE POOL

Syntax

SHOW COMPUTE POOL INSTANCE FAMILIES

Output

The command output provides compute pool instance family properties and metadata in the following columns:

ColumnDescription
nameInstance family name.
descriptionInstance family description.
vcpuNumber of vCPUs that are accessible to the user.
memory_gibMemory in GiB that is accessible to the user.
storage_gibStorage in GiB that is accessible to the user.
gpuName of the GPU if applicable, else an empty string.
gpu_countCount of GPUs if applicable, else 0.
gpu_memory_gibGPU Memory available per GPU if applicable, else 0.
current_node_usageNumber of nodes of this type currently in use by your Snowflake account.
messageAdditional information about the instance family.

Examples

The following command lists the compute pool instance families:

SHOW COMPUTE POOL INSTANCE FAMILIES;