
Insights
SQL
SQL queries, database management, and data analysis techniques (134 posts)
Browse the archive
Explore a topic across our insights
134 results · Page 1 of 8

How to make an AI agent accurate in BigQuery
A year ago, I wrote about getting a BigQuery warehouse ready for AI ( Easy ways to prepare your BigQuery warehouse for AI) , but didn't look properly into Knowledge Catalog (known as Dataplex at the time). We decided to go back and look through Google's Knowledge Catalog properly: what's actually in there, how it works and what it relates to. What Knowledge Catalog is Knowledge Catalog is Google's metadata layer for BigQuery data (and a few other sources). It sits alongside your tables rather

Webinar: We tried talking to our data - here’s what’s actually working (and what’s not)
In this 30-minute session, we unpacked what we had been experimenting with using Google’s conversational AI to spend less time wrangling data and more time actually learning from it.

#135 Twelve highlights of 2025 and future predictions
Dara and Matthew recap 2025 with 12 top highlights, AI, analytics, and the best moments on The Measure Pod.

Ask your data a question: the promise (and reality) of natural language to SQL
NL-SQL tools can transform how you query data - but only if your foundations are solid. Here's an honest look at what works and what doesn't.

#133 The role of AI in analytics (with Juliana Jackson at Jellyfish)
Dara and Matthew chat with Juliana Jackson on her journey, product mindset, and how AI is shaping modern analytics.

#132 The impact of AI on digital experience (with Yali Sassoon at Snowplow)
Yali Sassoon joins The Measure Pod to discuss Snowplow’s growth, AI innovation, data challenges, and the future of user experience.

#131 From raw export to insight-ready data (with Johan van de Werken at GA4Dataform)
Johan van de Werken joins The Measure Pod to discuss GA4Dataform, BigQuery, and the future of analytics engineering and automation.

#130 GenAI in action: Cloud DevOps and Tagassistant.ai (with Mark Edmondson)
In this episode of The Measure Pod, Dara and Matthew sit down with Mark Edmondson, AI Engineer, founder of Sunholo, Aitana, and board member at 8-bit-sheep.

#129 The impact of AI on digital analytics and user privacy (with Brian Clifton)
In this episode of The Measure Pod, Dara and Matthew sit down with Brian Clifton, the former Head of Web Analytics at Google (EMEA), author, and founder of Verified-Data.com and Advisor to Piwik PRO.

Webinar: Meet Dataform, the smart solution to fragile SQL setups
In this 30-minute webinar, learn how to bring structure and sanity to your SQL workflows, without adding complexity. We cover practical

#128 MCP servers in digital analytics (with Gunnar Griese at 8-bit-sheep)
In this episode of The Measure Pod, Dara and Matthew sit down with Gunnar Griese from 8-bit-sheep to discuss MCPs and their growing role in digital analytics.

#127 Ensuring robust data collection - lessons from Trackingplan (with Josele Perez)
In this episode of The Measure Pod, Dara and Matt welcome Josele Perez, co-founder of Trackingplan, to dive into the evolving challenges and opportunities in data collection.

#126 First-party data strategy - a client side perspective (with Roman Petrochenkov at Carwow)
In this episode of The Measure Pod, Dara and Matt sit down with Roman Petrochenkov, a seasoned marketing analytics leader with deep expertise in data strategy and measurement.

#125 Proactive pipelines - the power of shifting left (with Chad Sanderson at Gable)
In this episode of The Measure Pod, Dara and Matt are joined by Chad Sanderson from Gable.ai, a seasoned expert in the data space with a diverse background ranging from journalism to data science.

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 time points… without writing a single line of ML code… I probably would’ve asked how many coffees you’d had that day ☕️ But its a brand new world. And it’s possible. Let me explain What is TimesFM? TimesFM is a new foundation model from Google, built specifically for time-series forecasting. Think of it like GPT for time, instead of predicting the next word in a sentence, it predicts t

#124 Transforming tag management with server-side GTM (with Denis Golubovskyi at Stape)
In this episode of The Measure Pod, Dara and Matt are joined by Denis Golubovsky from Stape.io, the team making server-side Google Tag Manager implementation as simple as the click of a button.

#123 Why teams are turning to warehouse-native analytics (with István Mészáros at Mitzu)
In this episode of The Measure Pod, Dara and Matt are joined by István Mészáros, founder and CEO of Mitzu - a company who have built a warehouse-native product analytics solution.

#122 Digital transformation in the age of AI (with Antony Mayfield at Brilliant Noise)
In this episode of The Measure Pod, Dara and Mattew are joined by Antony Mayfield to talk about what 15+ years of digital transformation work actually looks like and how it’s changed.

