Categories:

System functions (System Information)

SYSTEM$GET_INSTANCE_FAMILY_PLACEMENT_GROUPS

Returns the list of placement groups supported for the specified instance family for Snowpark Container Services compute pool nodes.

语法

SYSTEM$GET_INSTANCE_FAMILY_PLACEMENT_GROUPS( '<instance_family>' )

实参

'instance_family'

实例系列。

返回

返回一个 VARCHAR 值，该值包含受支持的归置组的值，格式为 JSON 数组。

使用说明

  • The returned list of placement group names is specific to your Snowflake account and the specified instance family. For more information, see Compute pool placement.
  • Results don’t guarantee capacity. You might still run into insufficient capacity errors in a placement group even if an instance family is supported there.

示例

The following function returns the supported placement groups for the GPU_NV_L instance family:

SELECT SYSTEM$GET_INSTANCE_FAMILY_PLACEMENT_GROUPS('GPU_NV_L');

输出示例：

+--------------------------------------------------------------+
| SYSTEM$GET_INSTANCE_FAMILY_PLACEMENT_GROUPS('GPU_NV_L')      |
%--------------------------------------------------------------%
| ["A","B","C","D"]                                            |
+--------------------------------------------------------------+

The GPU_NV_L instance family is available in the following placement groups: A, B, C and D.