Load data into a BigQuery table from Google Cloud Storage using SQL
A short code example which loads a csv file from Google Cloud Storage into a table using SQL.
Analytical – Honest – Passionate
A short code example which loads a csv file from Google Cloud Storage into a table using SQL.
In my downtime I often play in my mind with different ways of explaining various parts and aspects of working with data. One recurring idea is the metaphor that compares …
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 …
Taking a look back at how my exercise and workout routines went over the year. If you are interested in how I record all of these stats then check out …
What Changed This year I made some changes to the infrastructure and analytics used on marquinsmith.com . Digital Ocean, who I use to host this WordPress website have increased there …
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 …
Some CSV files have issues with them. Below is a code snippet to save the information in a csv file into a duckdb database, ignoring all the ‘broken’ rows.