topic Primary Key not working as expected on Unity Catalog delta tables in Data Engineering

Primary Key not working as expected on Unity Catalog delta tables

AkasBala — Thu, 18 May 2023 02:26:09 GMT

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 ?

Re: Primary Key not working as expected on Unity Catalog delta tables

Miguel_Suarez — Fri, 09 Jun 2023 18:21:54 GMT

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-relationships

I hope this helps answer your question.

Best,

Miguel

Re: Primary Key not working as expected on Unity Catalog delta tables

Anonymous — Wed, 21 Jun 2023 07:12:57 GMT

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!

Re: Primary Key not working as expected on Unity Catalog delta tables

RobsonNLPT — Mon, 03 Jun 2024 11:18:52 GMT

what?? what does "constraint" mean?