Google’s AI Wants Your SQL Job. Plus, GA4 & Snap Are FINALLY Friends.

Another week, another chance for Google to casually drop updates that make you question your entire career path. Don’t worry, we read the endless release notes so you don’t have to.

Here’s what you actually need to know to stay ahead of the curve (and your competition).

Google BigQuery

Your data warehouse just got a brain transplant. Seriously.

• Gemini AI Writes Your SQL Now: Google’s AI assistant, Gemini, can now autocomplete your SQL queries. It’s like having a senior data analyst whispering in your ear, minus the condescending sighs. This is currently in Preview.
• Time Travel is Real: Ever wish you could see what your data looked like before that intern ran a bad query? The FOR SYSTEM_TIME AS OF clause for Iceberg tables now lets you query historical data snapshots.
• Peek Inside Your JSON: The new JSON_KEYS function lets you easily list all the keys in a JSON object, saving you from writing gnarly, complicated queries to explore your event data.
• Talk to PostgreSQL Without Leaving BQ: You can now query your PostgreSQL data in Spanner directly from the BigQuery interface. No more painful ETL processes. This is now Generally Available.

Why This BigQuery Update Matters:

• For Founders/Directors: The Gemini AI feature is a massive step toward democratizing data. Your less technical team members can now get closer to answering their own complex questions, reducing the bottleneck on your data team and accelerating insights.
• For Agency Owners: This is an efficiency goldmine. Reduce the time your team spends writing and debugging SQL. The time-travel feature is also a lifesaver for proving value and diagnosing campaign data issues, letting you say, “Here’s exactly what our tracking data looked like on the day the campaign launched.”
• For Marketers: The JSON_KEYS function makes exploring GA4 event data (which is full of nested JSON) infinitely easier. The Snap Ads integration means less time in spreadsheets and more time optimizing campaigns based on a complete ROAS picture.

Link to Their Documentation: BigQuery Release Notes

Google Analytics

• Snapchat & GA4 Are Finally Friends: You can now import cost and campaign data directly from Snapchat Ads into Google Analytics 4. The multi-channel ROAS report just got a whole lot more accurate.

Why This Analytics Update Matters:

• One Dashboard to Rule Them All: Finally, you can analyze Snapchat’s ad performance alongside Google, Meta, and other channels directly within GA4. No more VLOOKUPs or blended data nightmares in Looker Studio.
• Smarter Budget Allocation: With accurate cost data in one place, you can make faster, more confident decisions about where to shift your ad spend for the highest return. It’s a massive win for any performance marketer running social campaigns.

Link to Their Documentation: Import Snap Ads Data

The Snooze Button Section (Tools Without Updates)

Sometimes no news is good news. Or it just means the product teams are on vacation.

• Google Tag Manager: No new updates.
• Google Looker Studio: No new updates.
• PostHog: No new updates.