JSON

AS_OBJECT

Snowflake

Cast VARIANT ke OBJECT type. Return NULL jika VARIANT bukan object.

Tipe hasil: OBJECT

Syntax

SQL

AS_OBJECT(variant)

Parameter

variantVARIANTwajib

VARIANT yang akan di-cast ke OBJECT

Contoh Penggunaan

Safe Cast to Object

SQL

1 SELECT
2   AS_OBJECT(PARSE_JSON('{"a": 1}')) as valid_object,
3   AS_OBJECT(PARSE_JSON('[1,2,3]')) as array_returns_null,
4   AS_OBJECT(PARSE_JSON('"string"')) as string_returns_null;

Cast berbagai VARIANT ke OBJECT.

Hasil

valid_object	array_returns_null	string_returns_null
{"a": 1}	NULL	NULL

Kembali ke Snowflake Functions

1	SELECT
2	AS_OBJECT(PARSE_JSON('{"a": 1}')) as valid_object,
3	AS_OBJECT(PARSE_JSON('[1,2,3]')) as array_returns_null,
4	AS_OBJECT(PARSE_JSON('"string"')) as string_returns_null;