Published inThe Data to Value BlogHow 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-cases4d ago4d ago
Published inThe Data to Value BlogComputing Actual Physical vs. Logical Storage Costs in BigQueryHow to identify immediate potential cost savings, by determining the optimal storage billing model for each BigQuery datasetJun 4Jun 4
Published inThe Data to Value BlogAnalyzing 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 billMay 29A response icon1May 29A response icon1
Published inThe Data to Value BlogData to Value ToolsAn Open-Source Google BigQuery Toolkit for Analytics EngineersMay 19A response icon2May 19A response icon2
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, 2024A response icon3Aug 27, 2024A response icon3
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, 2024A response icon1Jun 21, 2024A response icon1
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