Published inThe Data to Value BlogA Practical Guide to BigQuery Cost OptimizationA set of best practices to improve performance and reduce costs in Google BigQueryAug 273Aug 273
Published inTowards Data ScienceUnderstanding the GA4 BigQuery Export Schema and StructureA qualitative investigation into one of the weirdest data structures ever forced upon millions of innocent, unsuspecting analystsJun 21Jun 21
Published inDecode DataA Guide to Functional Data Engineering in BigQueryAn exploration of the Functional Data Engineering paradigm and how to implement this in BigQueryJun 14Jun 14
Published inDecode DataHow to Build a Simple Data Stack on BigQueryBuilding data infrastructure on BigQuery is a highly capable, escalable, extensible, accessible and future-proof choice for any team or…Jun 5Jun 5
Published inDecode 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 BigQueryMar 27Mar 27
Published inTowards Data ScienceGoogle Pub/Sub to BigQuery the Simple WayA hands-on guide to implementing BigQuery Subscriptions in Pub/Sub for simple message and streaming ingestionSep 21, 2023Sep 21, 2023
Published inTowards 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 SQLAug 5, 20224Aug 5, 20224
Published inTowards 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 functionalityMay 25, 2022May 25, 2022
Published inTowards Data SciencePlotting Bar Charts in BigQuery Using a SQL User Defined Function (UDF)Minimise context switching and make your workflow fasterMar 15, 20221Mar 15, 20221
Published inTowards Data ScienceSQL String Templating in BigQuery: Four MethodsPowerful foundational techniques to help unlock the power of BigQuery scripting and automationJan 3, 20221Jan 3, 20221