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 27, 20243Aug 27, 20243
Published inTDS ArchiveUnderstanding the GA4 BigQuery Export Schema and StructureA qualitative investigation into one of the weirdest data structures ever forced upon millions of innocent, unsuspecting analystsJun 21, 2024Jun 21, 2024
Published inDecode DataA Guide to Functional Data Engineering in BigQueryAn exploration of the Functional Data Engineering paradigm and how to implement this in BigQueryJun 14, 2024Jun 14, 2024
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 5, 2024Jun 5, 2024
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 27, 2024Mar 27, 2024
Published inTDS ArchiveGoogle 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 inTDS ArchiveHow 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 inTDS ArchiveGetting 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 inTDS ArchivePlotting Bar Charts in BigQuery Using a SQL User Defined Function (UDF)Minimise context switching and make your workflow fasterMar 15, 20221Mar 15, 20221
Published inTDS ArchiveSQL String Templating in BigQuery: Four MethodsPowerful foundational techniques to help unlock the power of BigQuery scripting and automationJan 3, 20221Jan 3, 20221
