JSON

PARSE_JSON

BigQuery

Mengkonversi JSON string menjadi JSON native type.

Tipe hasil: JSONDiperbarui: 7 Jan 2026

Syntax

SQL

PARSE_JSON(json_string)

json_stringSTRINGwajib

String JSON yang valid

SQL

1 SELECT
2   PARSE_JSON('{"name": "John", "age": 30}') as parsed_json,
3   JSON_VALUE(PARSE_JSON('{"name": "John"}'), '$.name') as name;

Parsing string ke JSON lalu ekstrak value.

Hasil

parsed_json	name
{"name":"John","age":30}	John

SQL

1 SELECT
2   SAFE.PARSE_JSON('invalid json') as safe_parsed,
3   SAFE.PARSE_JSON('{"valid": true}') as valid_parsed;

Safe parsing mengembalikan NULL untuk invalid JSON.

Hasil

safe_parsed	valid_parsed
NULL	{"valid":true}

PARSE_JSON

Snowflake

JSON

DuckDB

1	SELECT
2	PARSE_JSON('{"name": "John", "age": 30}') as parsed_json,
3	JSON_VALUE(PARSE_JSON('{"name": "John"}'), '$.name') as name;

1	SELECT
2	SAFE.PARSE_JSON('invalid json') as safe_parsed,
3	SAFE.PARSE_JSON('{"valid": true}') as valid_parsed;