Spanner

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…

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…

Spanner supports <a href="https://docs.cloud.google.com/spanner/docs/latency-points#direct_connectivity">direct connectivity</a>. When enabled, your application traffic is routed directly to Spanner…

Spanner Graph supports a suite of <a href="https://docs.cloud.google.com/spanner/docs/graph/graph-algorithms-overview">graph algorithms</a> covering use cases such as fraud detection, entity…

You can optimize Spanner Graph query performance by using factorized execution. If a graph pattern traversal generates duplicate intermediate results, add the @{factorize_mode} hint to the pattern…

The Spanner change streams default <a href="https://docs.cloud.google.com/spanner/docs/change-streams#data-retention">retention period</a> has been increased from 1 day to 7 days. This change affects…

Spanner supports the FACTORIZED_MODE join hint. You can control which sides of a join to factorize (deduplicate) before executing the join by using the FACTORIZE_LEFT, FACTORIZE_RIGHT, or…

Spanner <a href="https://docs.cloud.google.com/spanner/docs/vector-indexes">vector index</a> and <a href="https://docs.cloud.google.com/spanner/docs/find-approximate-nearest-neighbors">approximate…

Spanner full-text search supports <a href="https://docs.cloud.google.com/spanner/docs/full-text-search/search-query-enhancement#custom-dictionaries">custom dictionaries</a> to create custom synonym…

The <a href="https://docs.cloud.google.com/spanner/docs/use-spanner-mcp">Spanner remote MCP server</a> is generally available (<a…

You can now use Spanner Studio to <a href="https://docs.cloud.google.com/spanner/docs/graph/create-update-drop-schema-visually">visually create and manage a Spanner Graph schema</a>. Visual modeling…

You can use the <a href="https://docs.cloud.google.com/spanner/docs/reference/mcp/databaseinsights/mcp">Database Insights remote MCP server</a> to analyze Spanner's performance and system…

Columnar engine for Spanner is now <a href="https://cloud.google.com/products/#product-launch-stages">generally available (GA)</a>. Columnar engine is a storage technique used with analytical queries…

Spanner supports Gemini Cloud Assist investigation capabilities. You can create, run, and edit <a href="https://docs.cloud.google.com/cloud-assist/investigations">Gemini Cloud Assist…

Repeatable read isolation is <a href="https://docs.cloud.google.com/products#product-launch-stages">generally available</a>. You can use it to reduce latency and transaction failure rates for…

Spanner supports importing data from Cloud SQL for MySQL. This feature lets you migrate the schema and perform a one-time bulk data load to evaluate Spanner for your use case. For more information,…

You can create BigQuery <a href="https://docs.cloud.google.com/bigquery/docs/materialized-views-create#spanner">non-incremental materialized views over Spanner data</a> to improve query performance…

You can use <a href="https://docs.cloud.google.com/bigquery/docs/export-to-spanner#export_using_a_cloud_resource_connection">Cloud resource connections with EXPORT DATA statements</a> to reverse ETL…

Spanner now offers <a href="https://docs.cloud.google.com/spanner/docs/reference/standard-sql/ml-functions">AI functions</a>, as a part of machine learning functions, that help you perform…

Spanner supports the optimistic concurrency control mode. Optimistic concurrency control is suitable for transactional workloads with low read-write contention. It assumes that conflicts in…

You can use <a href="https://docs.cloud.google.com/bigquery/docs/export-to-spanner#export_continuously">continuous queries to stream BigQuery data to Spanner in real time</a>. This feature is <a…

Spanner supports the following: • <a href="https://docs.cloud.google.com/spanner/docs/editions-overview#monitor-edition-feature-usage">Monitor the usage of Enterprise edition and Enterprise Plus…

Spanner supports the following <a href="https://docs.cloud.google.com/spanner/docs/managed-autoscaler">managed autoscaler</a> features: • Autoscaling based on <a…

Control of MCP use with organization policies is deprecated. After March 17, 2026, organization policies that use the gcp.managed.allowedMCPServices constraint won't work, and you can control MCP use…