Jim BarlowinDecode DataEssential SQL Functions for the GA4 BigQuery Events ExportThe fundamental functions you’ll need to master if you want to work with the GA4 events export in BigQuery5 min read·Mar 27, 2024----
Jim BarlowinTowards Data ScienceGoogle Pub/Sub to BigQuery the Simple WayA hands-on guide to implementing BigQuery Subscriptions in Pub/Sub for simple message and streaming ingestion·8 min read·Sep 21, 2023----
Jim BarlowinTowards Data ScienceHow to Build a Unique MD5 Row Hash Using SQL in BigQuery (Plus a Few Related Things)Using native BigQuery functionality to generate a dynamic, unique row identifier in SQL·9 min read·Aug 5, 2022--4--4
Jim BarlowinTowards Data ScienceGetting Started with BigQuery SQL User Defined Functions (SQL UDFs)A powerful and fundamental building block which enables custom extension of the core BigQuery platform functionality·5 min read·May 25, 2022----
Jim BarlowinTowards Data SciencePlotting Bar Charts in BigQuery Using a SQL User Defined Function (UDF)Minimise context switching and make your workflow faster·9 min read·Mar 15, 2022--1--1
Jim BarlowinTowards Data ScienceSQL String Templating in BigQuery: Four MethodsPowerful foundational techniques to help unlock the power of BigQuery scripting and automation·7 min read·Jan 3, 2022--1--1
Jim BarlowinTowards Data ScienceGetting Started with BigQuery ScriptingDemystifying this powerful but potentially difficult to grasp aspect of BigQuery functionality, one simple step at a time·4 min read·Nov 10, 2021----
Jim BarlowinDev GeniusConnecting BigQuery to Colab and Converting Query Results to Python DictionariesA simple method for working with BigQuery results in Python (for pandaphobes)·3 min read·Apr 27, 2021----
Jim BarlowinTowards Data ScienceGoogle Cloud Storage (GCS) to BigQuery the simple wayBecause simple is better than complex.·6 min read·Apr 22, 2021--1--1
Jim BarlowHow to explore the history of word usage using Google BooksAnalyse the contents of over 25 million books in a matter of seconds·3 min read·May 18, 2020----