BigQuery supports WHERE clauses inside aggregate function calls in preview

PreviewSep 14, 2026VerifiedAdded Sep 22, 2026

Aggregate function calls can now include a WHERE clause that filters their input with a boolean expression, simplifying conditional aggregation in SQL.

Developer tools

Read Google Cloud's release notes

https://docs.cloud.google.com/bigquery/docs/release-notes#September_14_2026

Summaries of vendors' own notes. Product names and logos belong to their owners; logos via logo.dev.

More BigQuery releases

BigQuerySep 14, 2026

An updated version of the Simba ODBC driver for BigQuery is now available

An updated version of the Simba ODBC driver for BigQuery is now available.

UpdateSQLSource

BigQuerySep 14, 2026

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 .

PreviewSQLGovernanceData integrationSource

BigQuerySep 16, 2026

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.

PreviewSQLGovernancePricingSource

BigQuerySep 17, 2026

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).

GASQLData integrationSource

BigQuerySep 10, 2026

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.

PreviewSQLSource

BigQuerySep 10, 2026

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.

PreviewSQLGovernanceObservabilitySource

BigQuerySep 10, 2026

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 .

PreviewSource

BigQuerySep 10, 2026

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.

GAAI agentsSQLData integrationSource

Also shipped on Sep 14, 2026

Snowflake Snowflake Cortex AISep 14, 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.

PreviewSQLData integrationSource

Snowflake SnowflakeSep 14, 2026

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 .

GASQLSource

Databricks AI/BI and GenieSep 14, 2026

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 .

PreviewBISource

Microsoft Microsoft FabricSep 14, 2026

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?

GASQLPricingObservabilitySource

Anthropic Claude PlatformSep 14, 2026

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.

BetaLLMsDeveloper toolsSource

Anthropic Claude PlatformSep 14, 2026

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.

BetaLLMsObservabilityDeveloper toolsSource