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

JamesY
New Contributor III

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