Primary Key not working as expected on Unity Catalog delta tables

AkasBala
New Contributor III

‎05-17-2023 07:26 PM

Hi @Chetan Kardekar. I noticed that you had commented on Primary key on Delta tables. Do we have that feature already released in DataBricks Premium. I have a Unity Catalog and I created a table with Primary Key, though it doesnt act like Primary Key and is taking duplicate values on the key column. Any thoughts ?

Labels:
0 Kudos

Miguel_Suarez
Databricks Employee
Databricks Employee

‎06-09-2023 11:21 AM

Hey @Bala Akas​ ,

You can use Primary and Foreign key relationships on fields in Unity Catalog tables, but Primary and Foreign keys are informational only and are not enforced.

You can find more on Primary and Foreign keys here: https://docs.databricks.com/tables/constraints.html#declare-primary-key-and-foreign-key-relationship...

I hope this helps answer your question.

Best,

Miguel

0 Kudos

RobsonNLPT
Contributor III
In response to Miguel_Suarez

‎06-03-2024 04:18 AM

what?? what does "constraint" mean?

0 Kudos

Anonymous
Not applicable

‎06-21-2023 12:12 AM

Hi @Bala Akas​ 

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. 

We'd love to hear from you.

Thanks!

0 Kudos