You can see the latest product updates for all of Google Cloud on the Google Cloud release notes page.
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
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:
Ability to convert between
BYTES
and base32-encoded strings using FROM_BASE32 and TO_BASE32 functions.Support for ARRAY_IS_DISTINCT.
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 :
- Support for SELECT * REPLACE and SELECT * EXCEPT syntax.
- Documentation for Net functions.
September 28, 2020
The NUMERIC
data type is now generally available.
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
Published new documentation for migrating data to Cloud Spanner:
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
Cloud Spanner now supports importing data from other databases using the Avro to Cloud Spanner template.
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
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.
Newly published documentation: SQL best practices, Working with arrays in SQL, Using Cloud Spanner with Cloud Functions, Monitoring using Stackdriver, Applying IAM Roles for databases, instances, and projects, Integrating with other Google Cloud Platform services.
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.