Alright, listen up. While you were busy making pivot tables, Google decided to turn BigQuery into an absolute powerhouse this week. Let’s break down what you can actually do with these updates before your clients start asking why the competition is so far ahead.
Here are the tools that got a glow-up:
Google BigQuery
- Managed Disaster Recovery is Now Generally Available: Because losing your data is a fireable offense. https://cloud.google.com/bigquery/docs/managed-disaster-recovery
- One-Click Record Flattening in Data Prep: Untangle that nested GA4 data without wanting to throw your laptop out a window. https://cloud.google.com/bigquery/docs/data-prep-get-suggestions#flatten-records
- Create Remote ML Models from Vertex AI & Hugging Face: Yes, you can now run sophisticated AI models with simple SQL. https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create-remote-model-open
- Generate Embeddings Directly in BigQuery: The secret sauce for semantic search, anomaly detection, and advanced clustering is now built-in. https://cloud.google.com/bigquery/docs/reference/standard-sql/bigqueryml-syntax-generate-embedding
- Automatic Pipeline Processing & Cross-Region Sharing: Less setup friction and easier data sharing for your global team or clients. https://cloud.google.com/bigquery/docs/create-pipelines
Why This BigQuery Update Matters:
- For Agency Owners & Directors: The new ML features are your new secret weapon. You can now offer advanced services like predictive lead scoring, customer lifetime value (CLV) modeling, and churn prediction without hiring an expensive, dedicated ML team. The disaster recovery feature is a crucial selling point for enterprise clients, guaranteeing business continuity.
- For Marketers & Analysts: Stop wasting 80% of your time cleaning data. The one-click flattening of nested records (looking at you, GA4 event parameters) means you get to insights faster. You can now experiment with powerful AI models to build hyper-segmented audiences or run sentiment analysis on product reviews, all within the familiar BigQuery environment.
Link to Their Documentation: https://cloud.google.com/bigquery/docs
The “We’re On Vacation” List
The product managers for these tools were clearly out enjoying the last days of summer.
- Google Tag Manager: No new updates.
- Google Looker Studio: No new updates.
- Google Analytics: No new updates.
- PostHog: No new updates.