Databricks JDBC write to table with PK column, error, key not found.

JamesY — Tue, 25 Jun 2024 14:52:18 GMT

Hello, I am trying to write data to table, it works find before, but after I recreated the table with one column as PK, there is an error.

Unable to write into the A_Table table....key not found: id

What is the correct way of doing this?
PK column: [ID] [bigint] IDENTITY(1,1) PRIMARY KEY NOT NULL

Re: Databricks JDBC write to table with PK column, error, key not found.

NandiniN — Wed, 01 Jan 2025 11:31:27 GMT

Looks like the primary key column ID is not being found during the write operation.

Kindly verify the schema.

Use a command like below to create the table with id as the primary key.

CREATE TABLE A_Table ( ID BIGINT IDENTITY(1,1) PRIMARY KEY NOT NULL, -- other columns );

Documentations: