Unable to create table with primary key

[mano7438]

Hi Team,

Getting below error while creating a table with primary key,

"Table constraints are only supported in Unity Catalog."

Table script : 

CREATE TABLE persons(first_name STRING NOT NULL, last_name STRING NOT NULL, nickname STRING,CONSTRAINT persons_pk PRIMARY KEY(first_name, last_name));

[Debayan]

Hi, primary key is not supported outside Unity Catalog. 

Please refer: https://docs.databricks.com/en/tables/constraints.html#declare-primary-key-and-foreign-key-relations...

Please let us know if this helps, also, please tag @Debayan with your next comment which will notify me. Thanks!

[mano7438]

HI @Debayan 

I am creating inside unity catalog only because I have enabled unity catalog for my workspace. 

[Debayan]

Hi, this needs further investigation, could you please raise a support case with Databricks? 

[mano7438]

Hi @Debayan ,

I have enabled unity catalog for my SQL warehouse like below, Could you please verify, is this correct way of enabling unity catalog or am doing anything wrong. It will be good if u will provide correct steps for enabling unity catalog for workspace

Please find the attached screen shot

[Debayan]

Hi, Did you also enable it from the account console? https://docs.databricks.com/en/data-governance/unity-catalog/enable-workspaces.html#enable-your-work...

[mano7438 · Accepted solution]

Hi @Debayan ,

Yes enabled . Its working now. I am able to create table with primary key.