instance_families

Creates, updates, deletes, gets or lists an instance_families resource.

Overview

Name	instance_families
Type	Resource
Id	snowflake.warehouses.instance_families

Fields

The following fields are returned by SELECT queries:

list

A compute pool instance family.

Name	Datatype	Description
name	string	Name of the instance family. (example: CPU_X64_S)
current_node_usage	integer (int64)	Number of nodes currently utilizing this instance family
description	string	Description of the instance family. (example: Ideal for hosting multiple services/jobs while saving cost.)
gpu	string	GPU model (if applicable). (example: NVIDIA A10G)
gpu_count	integer (int64)	Number of GPUs.
gpu_memory_gib	integer (int64)	GPU memory in GiB (if applicable).
memory_gib	integer (int64)	Memory in GiB.
message	string	Additional information about the instance family. (example: )
storage_gib	number (double)	Storage in GiB.
vcpu	integer (int64)	Number of vCPUs.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	endpoint		Lists all available instance families that can be used when creating compute pools.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
endpoint	string	Organization and account identifier (orgname-accountname) (default: orgname-accountname)

SELECT examples

list

Lists all available instance families that can be used when creating compute pools.

SELECT
name,
current_node_usage,
description,
gpu,
gpu_count,
gpu_memory_gib,
memory_gib,
message,
storage_gib,
vcpu
FROM snowflake.warehouses.instance_families
WHERE endpoint = '{{ endpoint }}' -- required
;