JSON

TO_JSON

BigQuery

Mengkonversi nilai BigQuery ke tipe JSON native.

Tipe hasil: JSONDiperbarui: 7 Jan 2026

Syntax

SQL

TO_JSON(expression)

expressionanywajib

Nilai yang akan dikonversi ke JSON

SQL

1 SELECT
2   TO_JSON(STRUCT('John' as name, 30 as age)) as json_obj,
3   TO_JSON([1, 2, 3]) as json_array;

Mengkonversi STRUCT dan ARRAY ke JSON.

Hasil

json_obj	json_array
{"name":"John","age":30}	[1,2,3]

TO_JSON

PostgreSQL

TO_JSON

Snowflake

TO_JSON

DuckDB

1	SELECT
2	TO_JSON(STRUCT('John' as name, 30 as age)) as json_obj,
3	TO_JSON([1, 2, 3]) as json_array;