Release notes

This page documents production updates to Cloud Spanner. You can periodically check this page for announcements about new or updated features, bug fixes, known issues, and deprecated functionality.

You can see the latest product updates for all of Google Cloud on the Google Cloud page, browse and filter all release notes in the Google Cloud Console, or you can programmatically access release notes in BigQuery.

To get the latest product updates delivered to you, add the URL of this page to your feed reader, or add the feed URL directly: https://cloud.google.com/feeds/spanner-release-notes.xml

November 16, 2021

Cloud Spanner regional instances can now be created in Santiago (southamerica-west1).

November 04, 2021

Time to live (TTL) reduces storage costs, improves query performance, and simplifies data retention by automatically removing unneeded data based on user-defined policies.

October 29, 2021

The django-spanner plugin is now available, enabling you to use Cloud Spanner as a backend database for the Django Web framework. For more information, see Django ORM with Cloud Spanner.

October 13, 2021

You can now assign request tags and transaction tags in your application code to easily troubleshoot query performance, transaction latency, and lock contentions by correlating introspection statistics to application code.

October 12, 2021

The PostgreSQL interface is available in Preview, making the capabilities of Spanner accessible from the PostgreSQL ecosystem. The release supports a subset of the PostgreSQL SQL dialect, including core data types, functions, and operators. Applications can connect using updated Spanner drivers for JDBC, Java, Go, and Python. Starting initially with psql, community tools can connect using PGAdapter, a sidecar proxy that implements the PostgreSQL wire protocol. Sign up for the preview today.

October 06, 2021

You can now specify the statistics package for the query optimizer to use, to ensure predictability in your query plans.

August 31, 2021

The R2DBC driver for Cloud Spanner is available in Preview. This driver lets you connect to Cloud Spanner from fully reactive applications.

August 30, 2021

In the Cloud Console, a database's Query page now supports multiple query tabs so you no longer have to clear one query to create and run another. Additionally, you can enter multiple query and DML statements in a single query tab. When you do so, the Results and Explanation subtabs let you choose which statement's results or query plan you want to view. See A tour of the query editor for details.

Added support for changing the leader region location of a Cloud Spanner database.

Added support for the JSON data type. For more information, see Working with JSON data.

August 20, 2021

Cloud Spanner now creates dedicated backup jobs to take backups instead of using an instance's server resources. As a result, backup time is reduced and backup operations do not affect instance performance.

Views are now supported in Cloud Spanner databases. Use views to provide logical data-modeling to applications, to centralize query definitions and simplify maintenance, and to ensure stability of query definitions across schema changes. Learn more.

August 17, 2021

Released Query Optimizer version 3. Query Optimizer v3 is currently set to off by default in production.

August 04, 2021

Cloud Spanner now has an end-to-end latency guide. This guide describes the high-level components involved in a Cloud Spanner API request, and explains how to extract, capture, and visualize latencies associated with these components to know the source of the latencies.

August 03, 2021

Cloud Spanner regional instances can now be created in Toronto (northamerica-northeast2).

Added support for changing instance configuration (Preview).

July 21, 2021

Time to live (TTL) is now available in public preview. This feature lets database administrators periodically delete unneeded data from Cloud Spanner tables, and so decrease storage and backup costs and potentially increase query performance. To use this feature, a database owner defines a row deletion policy on a table schema.

July 20, 2021

Granular instance sizing is now available in public preview. Historically, the most granular unit for provisioning compute capacity on Spanner has been the node. To provide more granular control, we are introducing Processing Units (PUs); one Spanner node is equal to 1,000 PUs. You can now provision in batches of 100 PUs, and get a proportionate amount of compute and storage resources. Learn more.

July 19, 2021

Key Visualizer for Cloud Spanner is now available. Key Visualizer is an interactive monitoring tool to analyze usage patterns in Spanner databases. It reveals trends and outliers in important performance and resource metrics.

July 08, 2021

The NUMERIC data type is now supported as a valid key column type, so you can now use NUMERIC type columns when specifying primary keys, foreign keys, and secondary indexes.

June 30, 2021

Cloud Spanner now supports Cloud External Key Manager (Cloud EKM) when using customer-managed encryption keys. Cloud EKM also provides Key Access Justification to give you more visibility into key access requests.

June 29, 2021

Cloud Spanner regional instances can now be created in Delhi (asia-south2).

June 21, 2021

Cloud Spanner regional instances can now be created in Melbourne (australia-southeast2).

June 15, 2021

The SQL mathematical functions EXP, LN, LOG, LOG10 and SQRT now directly support NUMERIC data as input. You no longer need to cast NUMERIC data to FLOAT64 data before passing it as input to these functions.

June 11, 2021

You can now find common queries for monitoring and troubleshooting on the Query page in the Cloud Console. This page now has query templates to help you to access these introspection system tables: Query Stats, Read Stats, Transaction Stats, Lock Stats, and Oldest active queries.

June 04, 2021

We are replacing the Insert a row and Edit a row data forms in the Cloud Console with pre-populated DML query templates on the Query page. These templates provide you more flexibility when adding and editing data. Learn More

May 27, 2021

We've enhanced the experience for creating, updating, and deleting schemas in the Cloud Console. On a database's Overview page you'll now find a Write DDL link to the DDL editor where you can perform all these activities.

April 13, 2021

Transaction statistics now includes information about commit retries to help users debug performance issues caused by transaction aborts.

April 06, 2021

You can now track the progress of long-running index backfill operations through the gcloud command line tool, REST API, and RPC API. For more information, see Checking the progress of a secondary index backfill.

March 31, 2021

You can now use Customer-Managed Encryption Keys (CMEK) to protect databases in Cloud Spanner. CMEK in Cloud Spanner is now generally available. For more information, see CMEK.

You can now optionally specify the priority of data requests. For more information, see CPU utilization and task priority.

The maximum number of JOIN statements allowed in a query has increased from 15 to 20. Query limits.

March 24, 2021

Cloud Spanner regional instances can now be created in Warsaw (europe-central2).

March 17, 2021

The Cloud Console query page has been updated with a revamped query editor, which now offers improved autocomplete, prevalidation of your query, formatting options, and the ability to run a selection from your query. This update also includes a new query plan visualizer. For a tour of these features and to learn more, see Tuning a query using the query plan visualizer.

March 11, 2021

Cloud Spanner provides a new metric, CPU Utilization by operation types, which breaks down CPU usage by user-initiated operations. For more information, see CPU utilization metrics.

March 03, 2021

Cloud Spanner now supports point-in-time recovery (PITR), which lets you recover data from a specific point in time in the past.

March 01, 2021

You can now optionally receive the mutation count for a transaction in the commit response to optimize the transactions while staying within the mutation count limit. For more information, see Retrieving commit statistics for a transaction.

February 08, 2021

The Cloud Spanner Console now displays database storage utilization and warns you if you are approaching the recommended limit. For more information, see storage utilization metrics.

January 15, 2021

You can now run SQL queries to retrieve lock statistics to investigate lock conflicts in your database.

January 14, 2021

Query statistics now includes information about queries that failed, queries that timed out, and queries that were canceled by the user.

December 17, 2020

A new multi-region instance configuration is now available in Europe - eur6 (Netherlands/Frankfurt/Zurich).

A new multi-region instance configuration is now available in North America - nam12 (Iowa/Northern Virginia/Oregon/Oklahoma).

December 07, 2020

Cloud Spanner supports a new statement hint, LOCK_SCANNED_RANGES, allowing you to request an exclusive lock on a set of ranges scanned by a transaction.

November 09, 2020

A new multi-region instance configuration is now available in North America - nam8 (Los Angeles/Oregon/Salt Lake City).

October 29, 2020

The following updates for Cloud Spanner SQL are now available:

October 23, 2020

A new multi-region instance configuration is now available in North America - nam7 (Iowa/North Virginia/Oklahoma).

October 15, 2020

A new multi-region instance configuration is now available in North America - nam9 (North Virginia/Iowa/South Carolina/Oregon).

October 13, 2020

CHECK constraints is now generally available, allowing you to define a boolean expression on the columns of a table and require that all rows in the table satisfy the expression. For more information, see Creating and managing check constraints.

Generated columns support is now generally available, allowing you to define columns that are computed from other columns in a row. For more information, see Creating and managing generated columns.

October 08, 2020

The following updates to Cloud Spanner standard SQL are now available :

September 28, 2020

September 09, 2020

Cloud Spanner introduces a new introspection tool that provides insights into queries that are currently running in your database. Use Oldest Active Queries to analyze what queries are running and how they are impacting database performance characteristics.

August 20, 2020

A new multi-region instance configuration is now available in North America - nam11 (Iowa/South Carolina).

August 06, 2020

A new multi-region instance configuration is now available in North America - nam10 (Iowa/Salt Lake).

July 30, 2020

The Cloud Spanner emulator is now generally available, enabling you to develop and test applications locally. For more information, see Using the Cloud Spanner Emulator.

July 15, 2020

You can now run SQL queries to retrieve read statistics for your database over recent one-minute, 10-minute, and one-hour time periods.

June 08, 2020

A second multi-region instance configuration is now available in Europe - eur5 (London/Belgium).

A multi-region instance configuration is now available in Asia - asia1 (Tokyo/Osaka).

Cloud Spanner regional instances can now be created in Jakarta (asia-southeast2).

June 03, 2020

Cloud Spanner SQL now supports the following statistical aggregate functions - STDDEV, VARIANCE. For more information, see Statistical Aggregate Functions.

May 18, 2020

You can now run SQL queries to retrieve transaction statistics for your database over recent one-minute, 10-minute, and one-hour time periods.

April 20, 2020

Cloud Spanner regional instances can now be created in Las Vegas (us-west4).

April 17, 2020

Cloud Spanner Backup and Restore is now generally available, enabling you to create backups of Cloud Spanner databases on demand, and restore them. For more information, see Backup and Restore.

Query Optimizer Versioning is now generally available, enabling you to select which version of the optimizer to use for your database, application or query. For more information, see Query optimizer.

April 01, 2020

A beta version of the Cloud Spanner emulator is now available, enabling you to develop and test Cloud Spanner applications locally. For more information, see Using the Cloud Spanner Emulator.

March 19, 2020

The open-source C++ client library for Cloud Spanner is now available. To get started using C++ with Cloud Spanner, see this tutorial.

March 05, 2020

Foreign keys is now generally available. For more information, see Foreign keys overview.

February 24, 2020

Cloud Spanner regional instances can now be created in Salt Lake City (us-west3).

January 24, 2020

Cloud Spanner regional instances can now be created in Seoul (asia-northeast3).

December 18, 2019

Cloud Spanner regional instances can now be created in Frankfurt (europe-west3).

November 25, 2019

SQL queries now support the WITH clause. This clause lets you bind the results of subqueries to temporary tables which makes it easier to structure complex queries and optimize them for a faster execution time.

October 16, 2019

If you would like to use Hibernate ORM with Cloud Spanner, we now provide a guide to help you connect Hibernate ORM to Cloud Spanner.

September 25, 2019

All Cloud Spanner instances, including 1-node and 2-node instances, are now covered under the Service Level Agreement (SLA). Cloud Spanner now supports 99.99% monthly uptime percentage for all regional instances and 99.999% monthly uptime percentage for all multi-region instances under the Cloud Spanner SLA, regardless of instance size.

August 09, 2019

The Google Cloud Platform Console no longer provides a chart that shows the stacked throughput, by region, for instances with multi-region configurations. Instead, you can use the chart that shows total throughput for all regions. Learn more about monitoring with the GCP Console.

August 07, 2019

An open-source JDBC driver for Cloud Spanner is now available. This open-source driver enables Java applications to access Cloud Spanner through the Java Database Connectivity (JDBC) API.

July 31, 2019

Cloud Spanner regional instances can now be created in São Paulo (southamerica-east1).

June 26, 2019

You can now import and export Cloud Spanner data in CSV format. You can use this feature to copy CSV data between Cloud Spanner and traditional relational database management systems, in combination with tools such as the mysqldump tool for MySQL, the COPY statement for PostgreSQL, or the bcp tool for Microsoft SQL Server.

If you write your applications in Java with the Spring Framework, we now provide a guide to help you add Spring Data Cloud Spanner to your application. Spring Data Cloud Spanner can make it easier and more efficient to work with Cloud Spanner.

June 21, 2019

For SQL queries, Cloud Spanner now automatically uses any secondary indexes that are likely to make the query more efficient.

If you notice a performance regression in an existing query, follow these troubleshooting steps, and get support if you cannot resolve the issue.

May 15, 2019

The Google Cloud Platform Console and the Stackdriver Monitoring console now provide latency charts for Cloud Spanner. Use these charts to help you troubleshoot performance issues.

April 30, 2019

The Google Cloud Platform Console and the Stackdriver Monitoring console now provide CPU utilization charts for additional CPU utilization metrics. You can also set up alerts in Stackdriver Monitoring to track these metrics.

April 18, 2019

Cloud Spanner regional instances can now be created in Osaka (asia-northeast2).

March 14, 2019

Cloud Spanner now allows you to send multiple DML statements in one transaction using batch DML.

March 11, 2019

Cloud Spanner regional instances can now be created in Zürich (europe-west6).

February 01, 2019

January 17, 2019

Cloud Spanner regional instances can now be created in London (europe-west2).

Cloud Spanner regional instances can now be created in Sydney (australia-southeast1).

January 11, 2019

December 06, 2018

Announced general availability of the Java client library for Cloud Spanner.

November 26, 2018

Cloud Spanner regional instances can now be created in Hong Kong (asia-east2).

November 13, 2018

The GCP Console now displays query statistics, as measured by CPU usage, for Cloud Spanner queries over recent one-minute, 10-minute, one-hour, and one-day time periods. You can also run SQL queries over the SPANNER_SYS tables to retrieve recent query statistics.

October 29, 2018

Cloud Spanner multi-region instance configurations can now be created in Europe (eur3).

October 26, 2018

The gcloud command-line tool includes beta support for inserting, updating, and deleting table rows using Partitioned DML.

October 22, 2018

Cloud Spanner multi-region instance configurations can now be created in a second multi-region instance configuration in North America (nam6).

October 10, 2018

Cloud Spanner now supports Data Manipulation Language (DML) statements, including Partitioned DML.

August 17, 2018

You can now use the REST API or the gcloud command-line tool to export and import Cloud Spanner databases.

July 12, 2018

Cloud Spanner now supports exporting and importing databases using the GCP Console.

July 10, 2018

Cloud Spanner regional instances can now be created in Los Angeles (us-west2).

June 11, 2018

Cloud Spanner regional instances can now be created in Finland (europe-north1).

June 06, 2018

Published new and updated documentation for designing and updating schemas:

May 10, 2018

Cloud Spanner regional instances can now be created in Singapore (asia-southeast1).

April 26, 2018

Cloud Spanner regional instances can now be created in Oregon (us-west1).

Cloud Spanner regional instances can now be created in South Carolina (us-east1).

April 24, 2018

The gcloud command-line tool includes beta support for inserting, updating, and deleting rows in a table.

March 28, 2018

Cloud Spanner now supports the commit timestamp column option that you can use to automatically write the commit timestamp of a transaction into a column.

March 15, 2018

Cloud Spanner regional instances can now be created in the Netherlands (europe-west4).

March 02, 2018

Cloud Spanner now supports reading and querying data in parallel with multiple workers using the client libraries for Node.js and Ruby.

February 27, 2018

Cloud Spanner now supports reading and querying data in parallel with multiple workers using the client libraries for C#, Go, Java, and PHP.

Cloud Spanner regional instances can now be created in Montréal (northamerica-northeast1).

February 20, 2018

Cloud Spanner now supports both Admin Activity and Data Access audit logs as a part of Stackdriver Logging.

January 31, 2018

Announced general availability of IAM custom roles for Cloud Spanner.

January 18, 2018

Cloud Spanner regional instances can now be created in Northern Virginia (us-east4) and Mumbai (asia-south1).

November 14, 2017

Cloud Spanner multi-region instance configurations are now available. Multi-region instances can now be created in one continent (nam3) or three continents (nam-eur-asia1).

June 15, 2017

Cloud Spanner regional instances can now be created in Tokyo (asia-northeast1).

May 16, 2017

Announced general availability of the Cloud Spanner API.

February 14, 2017

Initial Beta release of Cloud Spanner API.

The version of the gcloud command-line tool that supports Cloud Spanner is being rolled out. It is expected to be completely available by February 16, 2017.

The Cloud Spanner UI in the Google Cloud Platform Console is being rolled out and will be available shortly.