Primary Key not working as expected on Unity Catalog delta tables

[AkasBala]

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 ?

[Miguel_Suarez]

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

[RobsonNLPT]

what?? what does "constraint" mean?

[Anonymous]

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!