BigQuery supports WHERE clauses inside aggregate function calls in preview
Aggregate function calls can now include a WHERE clause that filters their input with a boolean expression, simplifying conditional aggregation in SQL.
Also shipped Sep 14, 2026Google Cloud in September 2026 →
Multimodal AI_SUMMARIZE for automatic theme summarization (Public Preview)
Snowflake Cortex AI_SUMMARIZE is now available in public preview, enabling customers to summarize text and multimodal content, including images and documents, directly in Snowflake.
Zero-copy support for all table formats in interactive warehouses (General availability)
Support for all table formats in interactive warehouses is now generally available and is no longer in Preview .
Genie visualizations in Slack replies (Public Preview)
When a Genie response includes a chart, the visualization now appears as an image in the Slack reply. If you installed the Databricks Genie app for Slack previously, reinstall it to enable this. See Visualizations .
Diagnose Fabric Data Warehouse workloads with the SQL DW operations skill (Generally Available)
When a warehouse slows down, the investigation usually starts with more questions than answers. Was there a capacity spike? Did a specific query suddenly become expensive? Are requests failing, being canceled, or simply taking longer than usual?
Messages API adds on-demand conversation compaction in beta
With the compact-2026-09-04 beta header, the top-level compaction parameter returns a signed compaction block summarizing prior messages, which you send in their place on later requests. You choose when to compact, it can run in the background, and recent turns can be kept verbatim.
Claude API input_transformations adds thinking_mismatch_allowed entries in beta
Under the thinking-binding-controls-2026-08-01 beta header, input_transformations can report thinking_mismatch_allowed for thinking blocks that failed an unenforced prefix check. Logging these entries helps find conversation history edits in production traffic.
More from BigQueryEvery BigQuery release →
Metadata for BigQuery Graph is automatically ingested and searchable in Knowledge Catalog
Metadata for BigQuery Graph is automatically ingested and searchable in Knowledge Catalog . This feature is available in preview .
BigQuery migration lineage service enters preview
The migration lineage service visualizes data flow and connections in a source database to help plan a BigQuery data warehouse migration.
You can add unit tests to pipelines to validate your SQL transformation logic against mock datasets
You can add unit tests to pipelines to validate your SQL transformation logic against mock datasets. Unit tests for pipelines are generally available (GA).
BigQuery conversational analytics adds ML.CORRELATION in preview
Conversational analytics can now use ML.CORRELATION to calculate statistical correlations between a target column and one or more metric columns in a table.
BigQuery ML.METRICS evaluates predictions without a stored model
The preview ML.METRICS function computes classification or regression evaluation metrics on any table or query with actual and predicted values, with no need to create or reference a stored model.
You can use the AI.CAUSAL_EFFECT function to quantify the impact of specific interventions on time series data
You can use the AI.CAUSAL_EFFECT function to quantify the impact of specific interventions on time series data. This feature is in Preview .
BigQuery Data Engineering Agent integrates with BigQuery Graph
The Data Engineering Agent now uses BigQuery Graph for extra context between source and destination schemas, improving schema mapping accuracy in data engineering pipelines. It is generally available.