topic Primary/Foreign key Costraints on Delta tables? in Data Engineering

Primary/Foreign key Costraints on Delta tables?

Ruby8376 — Tue, 24 May 2022 17:37:23 GMT

Hi All!

I am using databricks in data migration project . We need to transform the data before loading it to SalesForce. Can we do Primary key/foreign key constraints on databricks delta tables?

Re: Primary/Foreign key Costraints on Delta tables?

-werners- — Wed, 25 May 2022 06:34:16 GMT

that is not yet possible. There are only NOT NULL and CHECK constraints.

https://docs.microsoft.com/en-us/azure/databricks/delta/delta-constraints

Re: Primary/Foreign key Costraints on Delta tables?

Anonymous — Wed, 01 Jun 2022 06:59:14 GMT

Hi @Ruby Rubi following- up did you get a chance to check @Werner Stinckens previous comments or do you need any further help on this?