CODEWITHSUNDEEP
sqlsql-servercsvimportdbeaver
Ikthezeus
Ikthezeus

Reputation: 105

DBeaver cannot import CSV with NULL in primary key

I have a SQL table that I want to import data directly into via a CSV file. Because the table is live and being added to via API calls I do not want to specify the primary key (APid) in my import as I want it to auto-increment it as the import is processed.

Whenever I try to import the CSV I get the following error:

Error message

This is despite me both removing the column APid from the CSV, and also setting DBeaver to skip the column on import.

My import settings are as follows:

Input file

Tables mapping

Data load settings

The APid column is defined as follows:

APid column

Ideally I would like to avoid importing the data to a temp table and copying across, is there a way for DBeaver to skip this column and auto-increment it as it imports the CSV?

Upvotes: 1

Views: 1128

Answers (1)

phancuongviet
phancuongviet

Reputation: 435

You do not need to remove APid in CSV file, the process will check it for you. All have to do select skip dropdown list in TableMapp section. It'worked for me!

Upvotes: 0

Related Questions