JSON

GET_PATH

Snowflake

Mengakses nested element dalam VARIANT menggunakan path string.

Tipe hasil: VARIANTDiperbarui: 6 Jan 2026

Syntax

SQL

GET_PATH(variant, path)

variantVARIANTwajib

Data VARIANT untuk diakses

pathVARCHARwajib

Path ke nested element (contoh: 'a.b.c' atau 'a[0].b')

SQL

1 SELECT GET_PATH(
2   PARSE_JSON('{"user": {"name": "John", "addresses": [{"city": "NYC"}]}}'),
3   'user.addresses[0].city'
4 ) as city;

Akses deeply nested value.

Hasil

"NYC"

JSON_EXTRACT_PATH

PostgreSQL

JSON_EXTRACT

MySQL

JSON_EXTRACT

BigQuery

JSON_EXTRACT

DuckDB

1	SELECT GET_PATH(
2	PARSE_JSON('{"user": {"name": "John", "addresses": [{"city": "NYC"}]}}'),
3	'user.addresses[0].city'
4	) as city;