JSON

AS_ARRAY

Snowflake

Cast VARIANT ke ARRAY type. Return NULL jika VARIANT bukan array.

Tipe hasil: ARRAY

Syntax

SQL

AS_ARRAY(variant)

variantVARIANTwajib

VARIANT yang akan di-cast ke ARRAY

SQL

1 SELECT
2   AS_ARRAY(PARSE_JSON('[1,2,3]')) as valid_array,
3   AS_ARRAY(PARSE_JSON('{"a": 1}')) as object_returns_null;

Cast VARIANT ke ARRAY dengan safe handling.

Hasil

valid_array	object_returns_null
[1,2,3]	NULL

1	SELECT
2	AS_ARRAY(PARSE_JSON('[1,2,3]')) as valid_array,
3	AS_ARRAY(PARSE_JSON('{"a": 1}')) as object_returns_null;