It’s been a while since I’ve started working on datasets with BigQuery. Most of the time, I need to generate reports for several teams that work with/love spreadsheets. There are multiple ways to extract and present data (Connecting to Data Studio, Google Sheets via OWOX, etc.), but today I’m just going to show you one way.
Extracting and Saving to Google Sheets
Have your query prepared, and for those of you starting out, here’s the general syntax.
SELECT * FROM `GCP_Project_Name.Dataset.Table`
There are 2 options you can choose from when extracting:
If your query is fairly…
Fascinated with the airline industry and anything data