Katie
BigQuery AI.GENERATE tutorial: turn SQL queries into AI-powered insights
BigQuery just got a major upgrade, you can now plug directly into Vertex AI using the new AI.GENERATE function. Translation:…
How to start forecasting in BigQuery with zero training
If you’d told me five years ago that I’d be forecasting product demand using a model trained on 100 billion…
Easy ways to prepare your BigQuery warehouse for AI
You’ve probably heard that AI is coming to make our lives easier, especially in tools like BigQuery. But here’s the…
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…
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…
How to debug your SQL in BigQuery
How often have you run your code in BigQuery only to find a bit of data missing that you KNOW…
MeasureFest October 2022: Why GA4 means you need to get on board with BigQuery
This is my first time speaking at any analyics conference, let alone MeasureFest, and I'm looking forward to sharing my…
How to review SQL code in BigQuery for duplication and errors
Sometimes we can spend hours, days or even weeks writing SQL in BigQuery. Hopefully what you have ended up with…