Tag: Google Cloud Platform
Running SQL Queries on a schedule in BigQuery | Part 2b: Cloud Functions
In this part of the series we will walkthrough how to set up a query to run at a regular interval using Python and Cloud Functions. This is useful particularly …
A personal health tracking tool
For a little while now I have been using a personal health tracking tool to monitor my progress in various areas such as strength exercises, weight management and mental hygiene …
Export BigQuery table to Google Cloud Storage
A code example for how to write BigQuery SQL to export a table to Google Cloud Storage in csv and parquet file formats. Parquet CSV
Execute queries in BigQuery in parallel using python
An example of how to run multiple queries in parallel.
Copying BigQuery tables to a new dataset with bq command line tool
With the bq command line tool moving multiple tables at a time from one BigQuery dataset to another can be done with a few lines of code. The tool can …
From email to data warehouse – Google Edition
Use the Google technology stack to automatically load csv files received over email into BigQuery. In the data world, sending data over email is something that has been around for …
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 …
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 …
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 …