Analytical – Honest – Passionate
A short code example which loads a csv file from Google Cloud Storage into a table using SQL.
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 …
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 …
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 …
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
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 …
An example of how to run multiple queries in parallel.
A lightweight example of saving some logs to an SQLite database in a python script.