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:
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
Sourse is the issue CSV file date format is not recognised as set in driver properties - default is used #11612