Spanner supports approximate aggregate functions for both GoogleSQL and PostgreSQL dialects
Update4 days agoUnverifiedAdded Oct 24, 2026
Spanner supports approximate aggregate functions for both GoogleSQL and PostgreSQL dialects. These functions produce statistical estimates of distinct counts, allowing you to compute results faster and save resources on large datasets compared to exact aggregation.
Topics: Postgres, Observability, Performance
More Spanner releases
Every Spanner releaseSpanner adds automatic parameterization of SQL query literals
Spanner converts hardcoded literals in CRUD-style queries such as primary key lookups, index lookups and key joins into parameters, so execution plans are cached and reused to cut latency and CPU costs.
Spanner queues are generally available (GA)
Spanner queues are generally available (GA) . Spanner queues provide transactional messaging to help you manage asynchronous work. The feature pairs this capability with the scalability and reliability of Spanner, letting you build event-driven applications. For more information, see the Spanner queues overview .
Spanner Graph adds semantic options and key uniqueness validation
CREATE PROPERTY GRAPH can set description and synonyms options on labels and properties to help natural language query interfaces, and a validate_element_key_uniqueness option controls validation at schema creation.
Spanner PostgreSQL dialect adds ILIKE and NOT ILIKE
PostgreSQL-dialect databases in Spanner now support the ILIKE and NOT ILIKE operators and the pg.ilike and pg.not_ilike functions for case-insensitive pattern matching.
Spanner PostgreSQL dialect supports the TABLESAMPLE operator
PostgreSQL-dialect Spanner databases can use TABLESAMPLE to select a random sample of a dataset.
Spanner supports expression indexes on scalar expressions
Secondary indexes can be built on scalar expressions over one or more columns, removing the need for dedicated generated columns just for indexing.
Spanner applies the 80,000 mutation limit per DML statement
The DML mutation limit now applies per statement instead of across the whole transaction, so transactions can run several DML statements that together exceed it. The 100 MiB commit size limit still applies.
Spanner dynamic channel pooling for Go and Java clients is GA
Dynamic channel pooling for gRPC channels prevents issues from under- or over-provisioned channels and reduces configuration overhead in the Go and Java client libraries. It is disabled by default.
Also shipped on Oct 20, 2026
Google Cloud in October 2026Cloudflare One Client for Windows (version 2026.8.2115.0)
A new GA release for the Windows Cloudflare One Client is now available on the stable releases downloads page . This hotfix addresses an issue building trusted certificate chains.
Cloudflare One Client for macOS (version 2026.8.2115.0)
A new GA release for the macOS Cloudflare One Client is now available on the stable releases downloads page . This hotfix addresses an issue building trusted certificate chains.
Online Feature Store (General availability)
Online Feature Store is now generally available and is no longer in Preview .
Cloudflare One Client for Linux (version 2026.8.2115.0)
A new GA release for the Linux Cloudflare One Client is now available on the stable releases downloads page . This hotfix addresses an issue building trusted certificate chains.
SurveyMonkey connector is available in Beta
The managed SurveyMonkey connector is now available in Lakeflow Connect in Beta . Workspace admins can control access to this feature from the Previews page. Use the connector to ingest surveys, survey structure, collectors, survey responses, and contacts from SurveyMonkey into Databricks.
Oracle Eloqua connector is available in Beta
The managed Oracle Eloqua connector is now available in Lakeflow Connect in Beta . Workspace admins can control access to this feature from the Previews page. Use the connector to ingest marketing data such as contacts, accounts, campaigns, email and form assets, form submissions, events, and website visitors from Oracle Eloqua into Databricks.