Skip to content
Live
Trending storyPast story

Databricks releases UNIQUE constraint preview

1 reports1 outlets15 days agoUpdate

The story so far

AI overview

Databricks has released the public preview of UNIQUE constraints in Unity Catalog Delta tables, allowing tables to declare constraints on multiple nullable columns, and supporting query optimizer to eliminate unnecessary joins and aggregations with the RELY tag. Users can associate UNIQUE constraints with primary keys and foreign keys to optimize query performance.

AI-written from the reports · Updated 15 days ago

Coverage timeline

Follow the coverage to see every side of the story.

4 Nov
  1. Databricks Blog
    Declare and optimize with UNIQUE constraints on Databricks

    Databricks has released the public preview of UNIQUE constraints in Unity Catalog Delta tables, allowing tables to declare constraints on multiple nullable columns, and supporting query optimizer to eliminate unnecessary joins and aggregations with the RELY tag. Users can associate UNIQUE constraints with primary keys and foreign keys to optimize query performance.