Tag: sql
Digital Analytics Masterclass
For those interested in the field of Digital Analytics I have put together this project based curriculum to take someone from “digital analytics curious” to having the technical skill set …
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
Using SQL in Google Sheets
SQL is a great language for analysing and slicing and dicing data. The folks at Google who build Google Sheets appreciate this too. So much so that they have built …
Execute queries in BigQuery in parallel using python
An example of how to run multiple queries in parallel.
Simple logging to SQLite database from python
A lightweight example of saving some logs to an SQLite database in a python script.
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 …