14 releases · 0 this month
Spanner Graph supports the following enhancements: You can create property graphs from SQL views that call remote functions ( Preview ) to compute node and edge properties. For more information, see Compute properties with remote functions . You can write simplified queries on schemaless dynamic properties without explicit conversions to SQL data types.
Spanner now supports the ON DELETE SET NULL foreign key action for both GoogleSQL and PostgreSQL dialects. This allows referencing columns to be set to NULL when a referenced row is deleted.
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.
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 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 .
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.
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.
PostgreSQL-dialect Spanner databases can use TABLESAMPLE to select a random sample of a dataset.
Secondary indexes can be built on scalar expressions over one or more columns, removing the need for dedicated generated columns just for indexing.
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.
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.
Spanner supports creating tables without defining primary keys. When you create a table without a primary key, Spanner creates a hidden rowid column that serves as the primary key. For more information, see Create a table without defining a primary key .
You can use Gemini in Spanner Studio to fix errors in your SQL queries. When you run a query that contains an error, you can click Fix to view a line-by-line comparison of your query and a recommended correction, along with an explanation of the change. This feature is available in Preview .
Globally distributed database.
Other Google Cloud products: AlloyDB, BigQuery, Cloud Run, Cloud SQL, Dataflow, Dataplex Universal Catalog, Gemini API, Gemini CLI, Gemini Enterprise, Gemini Enterprise Agent Platform, Google Kubernetes Engine, Looker, Pub/Sub
| Release-notes page | Site | Feed |
|---|---|---|
| Spanner docs.cloud.google.com | docs.cloud.google.com | RSS |
| Cloud SQL for MySQL docs.cloud.google.com | docs.cloud.google.com | RSS |
| Cloud SQL for PostgreSQL docs.cloud.google.com | docs.cloud.google.com | RSS |
| Colab Enterprise docs.cloud.google.com | docs.cloud.google.com | None |
| Dataflow docs.cloud.google.com | docs.cloud.google.com | RSS |
| Dataproc docs.cloud.google.com | docs.cloud.google.com | RSS |
| Firestore docs.cloud.google.com | docs.cloud.google.com | None |
| Gemini Enterprise – Business edition release notes support.google.com | support.google.com | None |
| Google Cloud all release notes docs.cloud.google.com | docs.cloud.google.com | RSS |
| Pub/Sub docs.cloud.google.com | docs.cloud.google.com | RSS |
| Vertex AI / Agent Platform docs.cloud.google.com | docs.cloud.google.com | RSS |
| Vertex AI generative AI docs.cloud.google.com | docs.cloud.google.com | None |
| Gemini Apps' release updates & improvements gemini.google | gemini.google | None |
Releasesby Glyph