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:

https://docs.databricks.com/ja/sql/language-manual/sql-ref-syntax-ddl-create-table-using.html

https://docs.databricks.com/ja/sql/language-manual/sql-ref-syntax-ddl-create-table-constraint.html