Back to feed
GCP·BigQueryfeature·
AI Insights

You can now include a WHERE clause inside of an aggregate function call to filter your aggregate function input using a boolean expression.

You can now include a WHERE clause inside of an aggregate function call to filter your aggregate function input using a boolean expression. This feature is in Preview.

Read original announcement

More from BigQuery

You can add unit tests to pipelines to validate your SQL transformation logic against mock datasets.Sep 17, 2026You can use the migration lineage service to visualize the data flow and connections in your source database and help...Sep 16, 2026An updated version of the Simba ODBC driver for BigQuery is now available.Sep 14, 2026Metadata for BigQuery Graph is automatically ingested and searchable in Knowledge Catalog.Sep 14, 2026