JSON
BigQuery
TO_JSON_STRING
BigQueryMengkonversi nilai BigQuery ke JSON string representation.
Tipe hasil:
STRINGDiperbarui: 7 Jan 2026Syntax
SQL
TO_JSON_STRING(expression [, pretty_print])Parameter
expressionanywajib
Nilai yang akan dikonversi
pretty_printBOOLopsional
Format dengan indentasi (default: false)
Contoh Penggunaan
JSON String Output
SQL
1 SELECT 2 TO_JSON_STRING(STRUCT('John' as name, 30 as age)) as compact, 3 TO_JSON_STRING(STRUCT('John' as name, 30 as age), TRUE) as pretty;
Compact vs pretty-printed JSON string.
Hasil
| compact | pretty |
|---|---|
| {"name":"John","age":30} | { |
| "name": "John", | |
| "age": 30 | |
| } |