topic Re: Unable to create table with primary key in Get Started Discussions

Unable to create table with primary key

mano7438 — Thu, 24 Aug 2023 06:29:45 GMT

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));

Re: Unable to create table with primary key

Debayan — Thu, 24 Aug 2023 07:13:22 GMT

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

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

Re: Unable to create table with primary key

mano7438 — Thu, 24 Aug 2023 07:15:03 GMT

HI @Debayan

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

Re: Unable to create table with primary key

Debayan — Fri, 25 Aug 2023 06:12:30 GMT

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

Re: Unable to create table with primary key

mano7438 — Fri, 25 Aug 2023 06:45:00 GMT

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

Re: Unable to create table with primary key

Debayan — Mon, 28 Aug 2023 12:21:26 GMT

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

Re: Unable to create table with primary key

mano7438 — Mon, 28 Aug 2023 12:23:10 GMT

Hi @Debayan ,

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