Databricks JDBC write to table with PK column, err...

JamesY · ‎06-25-2024

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

NandiniN · ‎01-01-2025

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:

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