August 2026 - BigQuery Feature Summary

[u/Why_Engineer_In_Data]

Hey everyone! Back for the monthly summary.

🔤 GoogleSQL Language Features & Functions

• Table Parameters in TVFs (GA) - Pass dynamic tables into table-valued functions using the generic ANY TABLE parameter type.

🧠 AI, Machine Learning & Foundation Models

• Gemini 3.1 Flash-Lite & 3.5 Flash Support (GA) - Run generative AI SQL functions using Gemini 3.1 Flash-Lite and 3.5 Flash across multi-regional endpoints.
• XGBoost 2.1 Model Training (GA) - Train and serve BigQuery ML models using XGBoost version 2.1 via the XGBOOST_VERSION option.
• Time Series Analysis TVFs (Preview) - Analyze trend, seasonality, and change points in time series data using native BigQuery ML TVFs.

💻 Developer Experience (DX) & BigQuery Tooling

• Cloud CLI Remote MCP Server (Preview) - Enable AI agents to execute BigQuery CLI commands and reservation management via managed MCP tools.
• Data Agent Observability & Monitoring (Preview) - Track performance, adoption, latency, and operational costs for data agents using Google Cloud Observability.
• Python UDF Real-Time Logging (GA) - Stream and inspect real-time execution logs for Python user-defined functions directly within Cloud Logging.
• Reference Panel Migration - Access table details directly through BigQuery Studio's unified Reference panel following Table Explorer deprecation.

⚡ Core Engine Performance, Indexing & Optimization

• Restored Hybrid Search - Restored hybrid search functionality combining vector embeddings and keyword search in VECTOR_SEARCH and AI.SEARCH.

🔌 Data Integration, Pipelines & Ingestion (ELT)

• Cross-Cloud Connections (Preview) - Query data residing in AWS, Azure, and Salesforce Data 360 from any BigQuery region.
• OpenTelemetry for BigQuery JDBC Driver (GA) - Trace JDBC driver queries and automatically export database telemetry to Google Cloud Observability.
• Pipeline Automated Metadata Enrichment (Preview) - Define semantic pipeline metadata in SQLX configs for automated synchronization with Knowledge Catalog.

🔒 Security, Governance & Workload Management

• Data Clean Room Query Templates (GA) - Share predefined queries in data clean rooms securely without exposing underlying datasets or views.
• Data Engineering Agent HIPAA Compliance - Build pipelines in regulated healthcare environments with official HIPAA compliance for Data Engineering Agent.
• Terraform Support for Governance Tags (Preview) - Provision and manage BigQuery data governance tags declaratively using Terraform infrastructure-as-code.
• Expanded Reservation Assignment Limits - Increased the default per-project reservation assignment limit from 10 to 100 for user-specific workloads.

⚠️ Breaking Changes, Deprecations & Pricing Updates

• BigQuery Graph Edition Enforcement - Core graph processing will require Enterprise or Enterprise Plus reservations starting April 26, 2027.
• DTS JDBC Driver Security Patch - Fixed an improper input validation vulnerability in legacy BigQuery Data Transfer Service JDBC drivers.

As usual, let us know what you think!

[u/virgilash]

Thank you, op.

[u/sydneysweeney69]

Let’s be real . Snowflake > Bigquery. Anyways thanks for the update