← All updates Databricks Update One-Pager Navy version
databricks Platform · Updated Jun 5, 2026

UNIQUE constraint support is now in Public Preview

Databricks SQL now supports informational UNIQUE constraints on Unity Catalog Delta Lake tables.

What it does

Databricks SQL now supports informational UNIQUE constraints on Unity Catalog Delta Lake tables. Foreign keys can reference UNIQUE columns, and RELY on a UNIQUE constraint enables join elimination and DISTINCT simplification on Photon enabled compute. Applies to: Databricks SQL Databricks Runtime Adds an informational primary key, an informational foreign key, or an informational unique constraint as part of a CREATE TABLE or CREATE MATERIALIZED VIEW statement.

Why it matters

Reduces operational overhead and unlocks new capabilities for data teams on Databricks.

Key capabilities
TIMESERIES
TIMESERIES
foreign\key\column
foreign\key\column
parent\table
parent\table
parent\column
parent\column
Limitations · remember
!key\column
Architecture
Databricks Platform → Platform
In short

Databricks SQL now supports informational UNIQUE constraints on Unity Catalog Delta Lake tables. Foreign keys can reference UNIQUE columns, and RELY on a UNIQUE constraint enables join elimination and DISTINCT simplification on Photon enabled compute.

Read the full documentation ↗
Key takeaway
Databricks SQL now supports informational UNIQUE constraints on Unity Catalog Delta Lake tables.
2026-06-05-unique-constraint-support-is-now-in-public-preview Generated by the Databricks Updates Agent · browse all updates