How to extract BigQuery Source in JSON format?

How to extract BigQuery Source in JSON format?

Add Comment
1 Answer(s)

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.

Expert Answered on July 16, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.