Data Analysis
Running SQL Queries on a schedule in BigQuery | Part 1: Scheduled Queries
A short walkthrough guide of setting up a scheduled query in BigQuery. The Google documentation for scheduled queries is here. Step 1: Create a query in the bigQuery interface that …
Data Analysis
Query Google Sheets from BigQuery
Important and valuable data is often kept in Google Sheets. Learn how to make use of this data from within BigQuery in this post. Google sheets is a very useful …
Data Analysis
Query BigQuery from Google Sheets
Exporting to csv manually then opening with Google Sheets is now a thing of the past with Connected sheets functionality. Connected sheets is the functionality within Google Sheets to directly …