How import CSV file to Dbeaver

DBeaver - SQL client software application and a database administration tool.

Select CSV to connect to CSV database:

If date format in your CSV file is standard for DBeaver, i.e. yyyy-MM-dd, there will be no issue and you can click on Finish.

But if dates in your CSV file have formats: dd/MM/yyyy, or M/dd/yyyy, etc., need to do additional steps:

Example

We have this Table with 30 columns:

In Driver Properties add dateFormat as in the csv file, i.e. M/dd/yyyy in our example, and add columnTypes for each column. Therefore, setting should be the following:

columnTypes: integer,integer,integer,string,integer,string,string,string,integer,string,date,date,string,string,integer,string,string,integer,integer,string,integer,float,integer,integer,integer,integer,string,date,date,string

Result

Sourse is the issue CSV file date format is not recognised as set in driver properties - default is used #11612