denim
denim

Reputation: 463

Loading data from BigQuery into Google Sheets using the command line

I am looking for a way to upload data from Big Query into Google Sheets using the bq command line. Could not find any relevant documentation on the topic.

Thanks in advance.

Upvotes: 0

Views: 374

Answers (1)

Daniel Zagales
Daniel Zagales

Reputation: 3034

If I am understanding your question correctly, in that you would like to execute a query using the bq command and have the results saved to a Google Sheet, that is not possible currently.

https://cloud.google.com/bigquery/docs/writing-results#saving-query-results-to-sheets

The documented option in the above link is to essentially use the UI and save the results after they are executed.

Upvotes: 2

Related Questions