PinnedInDecode DatabyJim Barlow·Apr 9Solving The GA4 BigQuery Export, Once and For AllHow to make the painful challenges posed by one of the most infuriating data structures of all time… simply disappear.A response icon2A response icon2
InDecode DatabyJim Barlow·May 13Exporting GA4 Event Data to Cloud Storage (GCS, S3, Azure)Setting your GA4 data free by exporting to one of three cloud storage destinations.
InThe Data to Value Tech BlogbyJim Barlow·Jun 10, 2025How to use JSON in BigQuery like a Data Engineering ProfessionalA practical guide to using JSON in BigQuery, with sample code patterns and function references for core foundational use-cases
InThe Data to Value Tech BlogbyJim Barlow·Jun 4, 2025Computing Actual Physical vs. Logical Storage Costs in BigQueryHow to identify immediate potential cost savings, by determining the optimal storage billing model for each BigQuery dataset
InThe Data to Value Tech BlogbyJim Barlow·May 29, 2025Analyzing Google Analytics 4 Storage Cost in BigQueryMetadata analysis deployed as a reusable, open-source function, to give immediate insight into this increasing cost on your cloud billA response icon1A response icon1
InThe Data to Value Tech BlogbyJim Barlow·May 19, 2025Data to Value ToolsAn Open-Source Google BigQuery Toolkit for Analytics EngineersA response icon2A response icon2
InThe Data to Value Tech BlogbyJim Barlow·Aug 27, 2024A Practical Guide to BigQuery Cost OptimizationA set of best practices to improve performance and reduce costs in Google BigQueryA response icon3A response icon3
InDecode DatabyJim Barlow·Jun 21, 2024Understanding the GA4 BigQuery Export Schema and StructureA qualitative investigation into one of the weirdest data structures ever forced upon millions of innocent, unsuspecting analystsA response icon1A response icon1
InDecode DatabyJim Barlow·Jun 14, 2024A Guide to Functional Data Engineering in BigQueryAn exploration of the Functional Data Engineering paradigm and how to implement this in BigQuery
InDecode DatabyJim Barlow·Jun 5, 2024How 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…
