Conversion

TYPEOF

Snowflake

Mengembalikan nama tipe data dari nilai VARIANT.

Tipe hasil: VARCHARDiperbarui: 6 Jan 2026

Syntax

SQL

TYPEOF(variant_expression)

variant_expressionVARIANTwajib

VARIANT untuk dicek tipenya

SQL

1 SELECT TYPEOF(PARSE_JSON('{"name": "John"}')) as type;

Mengecek tipe root element.

Hasil

OBJECT

SQL

1 SELECT
2   TYPEOF(data:name) as name_type,
3   TYPEOF(data:age) as age_type
4 FROM (SELECT PARSE_JSON('{"name": "John", "age": 30}') as data);

Mengecek tipe masing-masing field.

Hasil

name_type: VARCHAR, age_type: INTEGER

1	SELECT
2	TYPEOF(data:name) as name_type,
3	TYPEOF(data:age) as age_type
4	FROM (SELECT PARSE_JSON('{"name": "John", "age": 30}') as data);