Google Cloud リリースノートのページで、Google Cloud の最新のプロダクト更新情報をすべて確認できます。
プロダクトのアップデートに関する最新情報を受け取るには、このページの URL をフィード リーダーに追加するか、またはフィード URL ディレクトリ https://cloud.google.com/feeds/spanner-release-notes.xml を直接追加します。
March 23, 2023
You can create Cloud Spanner regional instances in Turin, Italy (europe-west12).
March 21, 2023
The following functions and expressions have been added to the GoogleSQL dialect:
March 20, 2023
You can now use Google Cloud tags to group and organize your Cloud Spanner instances, and to condition Identity and Access Management (IAM) policies based on whether an instance has a specific tag. For more information, see Control access and organize instances with tags.
March 17, 2023
Support for the GoogleSQL-dialect THEN RETURN clause and the PostgreSQL-dialect RETURNING clause is now generally available. For more information, see THEN RETURN and RETURNING.
The following functions have been added to the GoogleSQL dialect:
March 09, 2023
Cloud Spanner fine-grained access control is now generally available. Fine-grained access control combines the benefits of Identity and Access Management (IAM) with traditional SQL role-based access control. For more information, see About fine-grained access control.
March 03, 2023
Added support for the JSONB array data type in the PostgreSQL dialect. For more information, see Work with JSONB data.
March 01, 2023
Change streams are now supported for PostgreSQL-dialect databases.
February 27, 2023
A monthly digest of client library updates from across the Cloud SDK.
Java
Changes for google-cloud-spanner
6.36.0 (2023-02-08)
Features
Bug Fixes
Dependencies
- Update dependency com.google.cloud:google-cloud-monitoring to v3.11.0 (#2262) (d566613)
- Update dependency com.google.cloud:google-cloud-shared-dependencies to v3.2.0 (#2264) (b5fdbc0)
- Update dependency com.google.cloud:google-cloud-trace to v2.10.0 (#2263) (96f0c81)
6.36.1 (2023-02-21)
Bug Fixes
- Prevent illegal negative timeout values into thread sleep() method while retrying exceptions in unit tests. (#2268) (ce66098)
Dependencies
- Update dependency com.google.api.grpc:proto-google-cloud-spanner-executor-v1 to v1.2.0 (#2256) (f0ca86a)
- Update dependency com.google.cloud:google-cloud-monitoring to v3.12.0 (#2284) (0be701a)
- Update dependency com.google.cloud:google-cloud-shared-dependencies to v3.3.0 (#2285) (bb5d5c6)
- Update dependency com.google.cloud:google-cloud-trace to v2.11.0 (#2286) (3c80932)
- Update dependency org.graalvm.buildtools:junit-platform-native to v0.9.20 (#2280) (685d1ea)
- Update dependency org.graalvm.buildtools:native-maven-plugin to v0.9.20 (#2281) (f2aabc2)
Node.js
Changes for @google-cloud/spanner
6.7.1 (2023-01-23)
Bug Fixes
- Change of tag for fgac (#1780) (d75b6dd)
- codec: Use index to determine array struct member value (#1775) (fc2b695), closes #1774
6.7.2 (2023-02-17)
Bug Fixes
- Tests emit empty metadata before emitting unspecified error (14ef031)
Go
Changes for spanner/admin/database/apiv1
1.44.0 (2023-02-01)
Features
Python
Changes for google-cloud-spanner
3.27.1 (2023-01-30)
Bug Fixes
- Add context manager return types (830f325)
- Change fgac database role tags (#888) (ae92f0d)
- Fix for database name in batch create request (#883) (5e50beb)
Documentation
- Add documentation for enums (830f325)
The new System insights dashboard displays metrics and scorecards for the resources that your instance or database uses and helps you get a high-level view of your system's performance. For more information, see Monitor instances with system insights.
February 16, 2023
The Cloud Spanner regional endpoints feature has been moved to a future release. It is not currently available.
February 13, 2023
As of today, the list compute price for the following 9-replica Spanner multi-region configurations has been reduced: nam-eur-asia1 and nam-eur-asia3. For more details, see Cloud Spanner pricing.
February 09, 2023
The Google Cloud console for Spanner now displays the status and progress of copy backup long-running operations that you have initiated in the console. The operation is visible for 7 days.
February 07, 2023
Cloud Spanner now autocompletes and validates the syntax of your DDL statements when you use the Google Cloud console to write DDL statements for your PostgreSQL-dialect databases.
February 06, 2023
Cloud Spanner now supports regional endpoints. You can use regional endpoints if your data location must be restricted and controlled to comply with regulatory requirements.
January 31, 2023
Table sizes statistics are now generally available. They help you get insights into the size of individual tables in your database. For more information, see Table sizes statistics.
January 30, 2023
A monthly digest of client library updates from across the Cloud SDK.
Node.js
Changes for @google-cloud/spanner
6.7.0 (2023-01-17)
Features
Go
Changes for spanner/admin/database/apiv1
1.43.0 (2023-01-19)
Features
- spanner/spansql: Add support for change stream value_capture_type option (#7201) (27b3398)
- spanner/spansql: Support
default_leaderdatabase option (#7187) (88adaa2) - spanner: Add REST client (06a54a1)
- spanner: Inline begin transaction for ReadWriteTransactions (#7149) (2ce3606)
Bug Fixes
Java
Changes for google-cloud-spanner
6.35.0 (2023-01-12)
Features
- Add support for new cloud client test framework in google-cloud-spanner-executor (#2217) (d75ebc1)
- spanner: Add samples for fine grained access control (#2172) (77969e3)
Bug Fixes
Dependencies
- Update dependency com.google.cloud:google-cloud-monitoring to v3.8.0 (#2192) (fe7e755)
- Update dependency com.google.cloud:google-cloud-shared-dependencies to v3.1.1 (#2222) (7d3bcca)
- Update dependency com.google.cloud:google-cloud-trace to v2.7.0 (#2193) (da2b924)
- Update dependency org.graalvm.buildtools:junit-platform-native to v0.9.19 (#2180) (43b54e9)
- Update dependency org.graalvm.buildtools:native-maven-plugin to v0.9.19 (#2181) (b42eb38)
6.35.1 (2023-01-18)
Dependencies
- Update dependency com.google.cloud:google-cloud-monitoring to v3.9.0 (#2230) (717f70f)
- Update dependency com.google.cloud:google-cloud-trace to v2.8.0 (#2231) (557ea16)
- Update dependency org.graalvm.sdk:graal-sdk to v22.3.1 (#2238) (d5f5237)
- Update dependency org.junit.vintage:junit-vintage-engine to v5.9.2 (#2223) (3278f91)
6.35.2 (2023-01-24)
Dependencies
Python
Changes for google-cloud-spanner
3.27.0 (2023-01-10)
Features
- Add support for python 3.11 (#879) (4b8c2cf)
- Add typing to proto.Message based class attributes (4683d10)
Bug Fixes
- Add dict typing for client_options (4683d10)
- deps: Require google-api-core >=1.34.0, >=2.11.0 (4683d10)
- Drop packaging dependency (4683d10)
- Drop usage of pkg_resources (4683d10)
- Fix timeout default values (4683d10)
Documentation
December 22, 2022
The new Cloud Spanner Kafka connector publishes change streams records to Kafka for application integration and event triggering. For more information, see Build change streams connections to Kafka.
December 19, 2022
You can now use the ALTER INDEX statement to add columns into an index or drop non-key columns. For more information, see Alter an index.
December 14, 2022
Cloud Spanner now offers the Cloud Spanner change streams to Pub/Sub Dataflow template, which streams Cloud Spanner data change records and writes them into Pub/Sub topics.
You can now create a custom instance configuration and add optional read-only replicas to your custom instance configurations to scale reads and support low latency stale reads. For more information, see Regional and multi-region configurations.
December 12, 2022
Support for moving a Cloud Spanner instance is now generally available. You can request to move your Spanner instance from any instance configuration to any other instance configuration, including between regional and multi-region configurations. For more information, see Move an instance.
An update to Spanner change streams provides two new data capture types for change records:
NEW_VALUESmode captures only new values in non-key columns, and no old values. Keys are always captured.NEW_ROWmode captures the full new row, including columns that are not included in updates. No old values are captured.
Note that existing change streams remain set to OLD_AND_NEW_VALUES.
December 06, 2022
We identified an issue in how we calculate the Total Database Storage metric in multi-regional Spanner instances. This metric is used to calculate the charges for Spanner database storage.
Database storage is currently incorrectly reported lower than it actually is in multi-regional configurations, resulting in undercharging for database storage. We communicated a Service Announcement in October and started rolling out this change to pricing on December 1, 2022. Depending on your configuration, your Total Database Storage could increase by up to 25%.
For the majority of impacted customers, the impact on your total bill will be less than 0.5%. For those affected, you will notice an increase in database storage charges that reflect this corrected metric.
We waived the under-billed amount for all past billing cycles. Please note that this issue only affects multi-region configurations of Spanner. It does not affect regional configurations of Spanner. Additionally, the Total Backup Storage metric is not affected by this issue, and has always been reported correctly.
For more information, see Database storage prices.
December 05, 2022
New SQL syntax, RETURNING in the PostgreSQL dialect and THEN RETURN in Google Standard SQL, selects and returns data from rows that were just updated as part of a DML statement. This is especially useful for getting values from default or generated columns and can reduce latency over equivalent multi-statement transactions. The preview supports the Java, JDBC, Python, and Go Spanner clients as well as PostgreSQL drivers that connect through PGAdapter.
December 02, 2022
The number of concurrent database restore operations per instance that Cloud Spanner supports has increased from five to ten. For more information, see Backup and restore limits.
November 15, 2022
Time to live (TTL) is now supported in PostgreSQL-dialect databases. With TTL, you can reduce storage costs, improve query performance, and simplify data retention by automatically removing unneeded data based on user-defined policies.
Added support for the JSONB data type in the Cloud Spanner PostgreSQL dialect. For more information, see Work with JSONB data.
November 08, 2022
Cloud Spanner now supports cross-region and cross-project backup use cases. You can copy a backup of your database from one instance to another instance in a different region or project to provide additional data protection and compliance capabilities.
November 07, 2022
A weekly digest of client library updates from across the Cloud SDK.
Go
Changes for spanner/admin/database/apiv1
1.40.0 (2022-11-03)
Features
Java
Changes for google-cloud-spanner
6.4.4-sp.7 (2022-11-02)
Dependencies
November 03, 2022
Support for the NHibernate ORM is now generally available, enabling you to use Cloud Spanner as a backend database for the NHibernate framework. For more information, see NHibernate Dialect for Cloud Spanner.
October 31, 2022
A weekly digest of client library updates from across the Cloud SDK.
Java
Changes for google-cloud-spanner
6.32.0 (2022-10-27)
Features
- Enable client to server compression (#2117) (50f8425)
- Increase default number of channels when gRPC channel pool is enabled (#1997) (44f27fc)
- Update
result_set.prototo return undeclared parameters in ExecuteSql API (#2101) (826eb93)
Dependencies
- Update dependency com.google.cloud:google-cloud-monitoring to v3.6.0 (#2125) (7d86fe4)
- Update dependency com.google.cloud:google-cloud-shared-dependencies to v3.0.5 (#2122) (308a65c)
- Update dependency com.google.cloud:google-cloud-trace to v2.5.0 (#2126) (5167928)
- Update dependency org.graalvm.buildtools:junit-platform-native to v0.9.16 (#2119) (b2d27e8)
- Update dependency org.graalvm.buildtools:native-maven-plugin to v0.9.16 (#2120) (151cf77)
- Update dependency org.graalvm.sdk:graal-sdk to v22.3.0 (#2116) (9d6930b)
Node.js
Changes for @google-cloud/spanner
6.4.0 (2022-10-27)
Features
October 24, 2022
A weekly digest of client library updates from across the Cloud SDK.
October 19, 2022
The number of concurrent database restore operations per instance that Cloud Spanner supports has increased from one to five. For more information, see Backup and restore limits.
October 18, 2022
The following new generally available features help you identify and troubleshoot high latencies in specific databases:
The Lock insights dashboard helps you identify latency spikes that are due to lock contentions.
The Transaction insights dashboard helps you identify the transactions that cause lock contentions and, possibly, high latencies.
October 17, 2022
A weekly digest of client library updates from across the Cloud SDK.
Java
Changes for google-cloud-spanner
6.23.4 (2022-10-12)
Dependencies
Python
Changes for google-cloud-spanner
3.22.2 (2022-10-10)
Bug Fixes
October 11, 2022
Spanner Vertex AI integration is now available in public preview. You can now enhance your Spanner applications with machine learning capabilities by using Google Standard SQL. For more information, see About Spanner Vertex AI integration.
October 10, 2022
A weekly digest of client library updates from across the Cloud SDK.
Java
Changes for google-cloud-spanner
6.31.2 (2022-10-05)
Bug Fixes
- Update protobuf to v3.21.7 (ac71008)
6.31.1 (2022-10-03)
Dependencies
Python
Changes for google-cloud-spanner
3.22.1 (2022-10-04)
Bug Fixes
Documentation
- samples: Add samples for CMMR phase 2 (4282340)
October 03, 2022
A weekly digest of client library updates from across the Cloud SDK.
Java
Changes for google-cloud-spanner
6.31.0 (2022-09-29)
Dependencies
- Update dependency com.google.cloud:google-cloud-trace to v2.3.4 (#2027) (14890ed)
- Update dependency com.google.cloud:google-cloud-trace to v2.3.5 (#2083) (cef4e0a)
- Update dependency org.graalvm.buildtools:junit-platform-native to v0.9.14 (#2030) (04b59ff)
- Update dependency org.json:json to v20220924 (#2035) (a26a14a)
Python
Changes for google-cloud-spanner
3.22.0 (2022-09-26)
Features
September 28, 2022
The following SPANNER_SYS statistical tables have been enhanced with new columns:
- Transaction statistics:
TOTAL_LATENCY_DISTRIBUTION,OPERATIONS_BY_TABLE, andATTEMPT_COUNT. - Query statistics:
LATENCY_DISTRIBUTIONandRUN_IN_RW_TRANSACTION_EXECUTION_COUNT. - Read statistics:
RUN_IN_RW_TRANSACTION_EXECUTION_COUNT.
September 27, 2022
The number of mutations per commit that Cloud Spanner supports has increased from 20,000 to 40,000. For more information, see Quotas and limits.
The ARRAY_SLICE function is now available to use in Google Standard SQL. This function returns an ARRAY containing zero or more consecutive elements from an input array.
September 26, 2022
A weekly digest of client library updates from across the Cloud SDK.
Node.js
Changes for @google-cloud/spanner
6.2.0 (2022-09-16)
Bug Fixes
Go
Changes for spanner/admin/database/apiv1
1.39.0 (2022-09-21)
Features
- spanner/spannersql: Add backticks when name contains a hypen (#6621) (e88ca66)
- spanner/spansql: Add support for create, alter, and drop change streams (#6669) (cc4620a)
- spanner: Retry spanner transactions and mutations when RST_STREAM error is returned (#6699) (1b56cd0)
Bug Fixes
Java
Changes for google-cloud-spanner
6.30.2 (2022-09-21)
Dependencies
- Update dependency com.google.cloud:google-cloud-monitoring to v3.4.5 (#2022) (0536962)
- Update dependency org.junit.vintage:junit-vintage-engine to v5.9.1 (#2023) (3fb4235)
6.30.1 (2022-09-20)
Dependencies
September 15, 2022
Fine grained access control for Spanner is now available in public preview. Fine-grained access control lets you secure your Spanner databases at the table and column level by using new RDBMS-style roles and GRANT/REVOKE SQL statements. With fine-grained access control, you can protect your transactional data and ensure that the right controls are in place when granting access to data. For more information, see About fine-grained access control.
The Spanner Golang database/sql driver is now generally available. Add the driver to your application to enable the use of the database/sql package with Spanner. For more information, see the Spanner blog and the package documentation.
September 13, 2022
You can create Cloud Spanner regional instances in Tel Aviv, Israel (me-west1).
September 09, 2022
Query Optimizer version 5 is generally available, and is the default optimizer version.
September 08, 2022
Cloud Spanner free trial instances are now generally available. With a free trial instance, you can learn and explore Spanner for 90 days at no cost. You can create Google Standard SQL or PostgreSQL-dialect databases and store up to 10 GB of data, with the option to upgrade at any time. For more information, see About Cloud Spanner free trial instances.
August 17, 2022
The DISABLE_INLINE hint is now available to use in a Google Standard SQL function call. This allows a function to be computed once instead of each time another part of a query references it.
July 25, 2022
Query Optimizer version 5 is generally available. Version 4 remains the default optimizer version in production.
July 14, 2022
You can now view aggregated Cloud Spanner statistics related to transactions, reads, queries, and lock contentions in GA in Cloud Monitoring.
June 30, 2022
The ANALYZE DDL command allows administrators to manually update the query statistics package that the optimizer uses to build query execution plans. This complements the existing automatic updates to provide faster feedback cycles when data, queries, or indexes change frequently.
June 29, 2022
Query insights is now generally available. Query Insights helps you visually detect and identify query performance issues for Cloud Spanner databases. You can also dig deeper and analyse the query details to know the root cause of these issues.
To learn more, see Detect query performance issues with Query Insights.
June 23, 2022
The PostgreSQL interface is now generally available, making the capabilities of Cloud Spanner accessible from the PostgreSQL ecosystem. It includes a core subset of the PostgreSQL SQL dialect, support for the psql command-line tool, native language clients, and integration into existing Google tools. For more information, see PostgreSQL interface.
June 10, 2022
Commit timestamps enable a Cloud Spanner optimization that can reduce query I/O when retrieving data written after a particular time.
June 07, 2022
You can create Cloud Spanner regional instances in Dallas (us-south1).
May 31, 2022
Granular instance sizing is now generally available. You can now create production instances of fewer than 1000 processing units. To learn more, see Compute capacity, nodes and processing units.
May 27, 2022
Cloud Spanner change streams capture and stream out inserts, updates, and deletes in near real-time—useful for analytics, archiving, and triggering downstream application workflows.
May 24, 2022
You can create Cloud Spanner regional instances in Columbus (us-east5).
May 10, 2022
You can create Cloud Spanner regional instances in Madrid (europe-southwest1).
May 03, 2022
You can create Cloud Spanner regional instances in Paris (europe-west9).
Query Optimizer version 4 is generally available, and is the default optimizer version.
April 20, 2022
Cloud Spanner regional instances can now be created in Milan (europe-west8).
April 14, 2022
You can now define a default value for a non-key table column when creating or altering a table. Using the DEFAULT keyword, a schema author can provide a fallback for a column when an insert statement or mutation doesn't explicitly specify a value.
A new three-continent, nine-replica multi-region instance configuration is available for Cloud Spanner: nam-eur-asia3 (Iowa/South Carolina/Belgium/Netherlands/Taiwan/Oklahoma).
April 05, 2022
Cloud Spanner now allows you to export a subset of your database tables to Google Cloud Storage as Avro files.
March 25, 2022
All instances with a compute capacity of at least one node (1,000 processing units) now have a data storage allotment of 4 TB per node, an increase from 2 TB per node. Relatedly, instances smaller than one node now have a data storage allotment of 409.6 GB for every 100 processing units.
March 22, 2022
The data type of the COLUMN_DEFAULT column in the information schema COLUMNS table has changed from BYTES to STRING. This aligns better with industry standards and enables future improvements to Cloud Spanner.
March 10, 2022
Cloud Spanner now offers committed use discounts. You can get significantly discounted prices in exchange for your commitment to use Cloud Spanner compute resources continuously for a year or longer.
March 08, 2022
You can now see and manage the views of your Cloud Spanner databases from the Google Cloud Console. To do so, visit a database's Overview page, and then click the Views tab.
March 03, 2022
You can now view aggregated Cloud Spanner statistics related to transactions, reads, queries, and lock contentions in Preview in Cloud Monitoring. Additionally, the retention period for these metrics at one-minute intervals has been increased from six hours to six weeks.
March 01, 2022
A new multi-region instance configuration is now available in North America - nam13 (Iowa/Oklahoma/Salt Lake City).
Released Query Optimizer version 4. Version 3 remains the default optimizer version in production.
February 11, 2022
Cloud Spanner now optimizes the way it processes groups of similar statements in DML batches, significantly improving the speed at which it performs batched data writes under certain conditions.
February 08, 2022
Query statistics now cover DML statements, including inserts, updates, and deletes.
February 07, 2022
Cloud Spanner's CPU Utilization metrics now provide grouping by all task priorities: low, medium, and high.
Relatedly, Cloud Spanner's monitoring console now lets you view the CPU utilization of your instance by operation type, filtered by task priority.
January 25, 2022
Starting no sooner than February 23, 2022, the data type of the COLUMN_DEFAULT column in the information schema's COLUMNS table will change from BYTES to STRING. This aligns better with industry standards, and enables future improvements to Cloud Spanner.
November 16, 2021
Cloud Spanner regional instances can now be created in Santiago (southamerica-west1).
November 04, 2021
Time to live (TTL) is generally available. 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 27, 2021
When performing a CSV export, you may now use the spannerSnapshotTime option to export a specific past version of your data.
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.
September 24, 2021
Query Optimizer version 3 is now the default optimizer version in production.
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:
Ability to convert between
BYTESand 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.