BigQuery
Dataform for BigQuery: A basic end-to-end guide
Dataform is a powerful tool for managing your data workflows in a structured, version-controlled, and automated way. Whether you're a…
How to extract GA4's event sequencing in BigQuery using the new batch fields
Google Analytics 4 (GA4) exports event data to BigQuery, enabling detailed user behavior analysis. However, GA4 batches events before sending…
Automating BigQuery workflows with conditional logic and data readiness checks
BigQuery offers powerful scripting capabilities that can simplify complex workflows. In this post, we’ll explore two essential techniques: using IF...THEN...END…
Mastering data loading in BigQuery using Dataform
Efficient data loading is crucial for managing and updating tables in Dataform. Various strategies exist to handle different use cases,…
A step-by-step guide to migrating scheduled queries to Dataform
Managing scheduled queries in BigQuery often feels limiting — there’s no version control, no easy collaboration, and scaling can be…
How to set up a Dataform repository with GitHub & Google Cloud integration
Setting up a Dataform repository can be challenging without the right steps. Whether you’re new to Dataform or want to…
The complexity paradox: why your spreadsheet is complex and BigQuery is simple
Understanding complexity Everything is complex until you understand it. And yet, not all complexities are created equal. This is the…
You’re sitting on a SQL time bomb: defuse it with Dataform
As a marketing team's maturity evolves, disparate data sources centralise, increasingly sophisticated SQL queries begin to pull together insights and…
Elevate your data analytics game with BigQuery
What is BigQuery? What is BigQuery? BigQuery is a powerful data warehousing tool within the Google Cloud Platform designed to…
Connecting GPT to BigQuery: Zapier AI actions
Unless you have lived under a rock for the last 12 months, you have probably heard of a little old…