How to extract BigQuery Source in JSON format?
Diyotta has provided an option to extract the BigQuery table data in JSON fromat. For this, FileType must be chosen as JSON in extract properties. The syntax for the extract query is like below
SELECT TO_JSON_STRING(alias) FROM ` dataset.tableName` alias.
This is valid only for generic native.