SHOW COMPUTE POOL INSTANCE FAMILIES

Lists the available compute pool instance families that you can use to create a compute pool in the region of your current account.

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.

Usage notes

  • Instance family availability varies by region and can change over time. The output includes only the instance families that are available in the region of your current account. To check availability in a different region, run the command from an account in that region.

Examples

The following command lists the compute pool instance families available in the region of your current account:

SHOW COMPUTE POOL INSTANCE FAMILIES;