topic Error Creating Primary Key Constraint in Data Engineering

Error Creating Primary Key Constraint

najmead — Sat, 04 Feb 2023 11:23:07 GMT

I am trying to add a primary key constraint to an existing table, and I get the following error;

Cannot create or update table because the child column(s) `my_primary_key` of primary key `pk` cannot be set to nullable. Either drop the constraint, or change the column nullability.

This doesn't make sense to me... why would you want a primary key column to be nullable? In any event, I tried to alter the column to allow nulls and still got the same error.

I appreciate that primary keys and foreign keys in data bricks are informational only, but I want to be able to support downstream BI developers with this information if possible.

Re: Error Creating Primary Key Constraint

najmead — Mon, 06 Feb 2023 03:35:27 GMT

I'm not using databricks-sql-connector. I ran the query from the query editor within databricks itself.

Re: Error Creating Primary Key Constraint

Debayan — Sun, 05 Feb 2023 13:18:28 GMT

Hi, Could you please confirm if you are using the latest databricks-sql-connector ? (https://pypi.org/project/databricks-sql-connector/)