More than 3 years have passed since last update.

BigQueryでクエリ結果をJSONで取得する

BigQuery

Last updated at 2021-12-09Posted at 2021-12-09

やりたいこと

BigQueryにて、クエリ結果をJSONで取得する

やりかた

SELECT TO_JSON_STRING(t) FROM (SELECT hoge, fufa FROM sample_table) AS t

例

SELECT TO_JSON_STRING(t) AS j
FROM (
    SELECT 
        "hoge" AS foo,
        "fuga" AS bar
    UNION ALL 
    SELECT
        "piyo" AS foo,
        "nya" AS bar
) AS t

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up