Releasesby GlyphSpanner supports the ON DELETE SET NULL foreign key action for GoogleSQL and PostgreSQL dialects
Spanner supports the ON DELETE SET NULL foreign key action for GoogleSQL and PostgreSQL dialects. Use ON DELETE SET NULL when you delete a referenced row to set the referencing columns to NULL . For more information, see Foreign key actions and Create and manage foreign key relationships .
Also shipped Oct 27, 2026Google Cloud in October 2026 →
OpenAI GPT-6.1 Terra is now available on Unity Gateway
Databricks now supports the OpenAI GPT-6.1 Terra model via Foundation Model APIs on Unity Gateway.
Editing files in Unity Catalog volumes is now generally available
Users can now edit files stored in Unity Catalog volumes directly within the Databricks workspace file editor, eliminating the need for manual downloads and uploads.
Released pg\_pinecone
The pg_pinecone extension is now available, enabling native vector search within PostgreSQL. It allows users to perform vector searches using the local engine or offload indexing to Pinecone for larger datasets.
[Launched] Generally Available: Cost management and tagging for Claude models in Microsoft Foundry
Microsoft Foundry now provides integrated cost management and tagging for Claude models within Azure Cost Management. This update ensures Claude usage is tracked under the specific Foundry resource rather than as general SaaS spend.
Default OAuth apps for external AI agents are now generally available
Databricks now provides default OAuth client IDs for external AI agents like ChatGPT, Claude, and Cursor to connect to Databricks MCP servers. This removes the need for account admins to manually create OAuth apps.
AI Functions Unity Catalog permissions is now generally available
Unity Catalog permissions for AI Functions are now generally available. Metastore admins can now control access to specific AI functions within the system.ai schema.
More from SpannerEvery Spanner release →
Spanner supports equality and ordering comparisons on JSONB and JSON values
Spanner now allows equality and ordering comparisons on JSONB and JSON values directly in GROUP_BY and ORDER BY clauses. It also supports implicit type coercion and search indexes for JSON equality operations.
Spanner supports approximate aggregate functions for both GoogleSQL and PostgreSQL dialects
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 adds automatic parameterization of SQL query literals
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 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 .
Spanner Graph adds semantic options and key uniqueness validation
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.
Spanner PostgreSQL dialect adds ILIKE and NOT ILIKE
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.
Spanner PostgreSQL dialect supports the TABLESAMPLE operator
PostgreSQL-dialect Spanner databases can use TABLESAMPLE to select a random sample of a dataset.
Spanner supports expression indexes on scalar expressions
Secondary indexes can be built on scalar expressions over one or more columns, removing the need for dedicated generated columns just for indexing.