Import file using DBeaver

Question

I currently use Mysql Workbeanch and I want to move to DBeaver as it is an all in for multiple databases.

However I use a function to import a CSV from Amazon S3 buckets as follows

LOAD DATA FROM S3 's3-eu-west-2://csv-files/OCN04.txt'
INTO TABLE OCN
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS ;

This function does not work in DBEAVER

Answer 1

Load data infile works but i am guessing the file path is the issue here. I'm guessing that dbeaver only reads file from a specific directory. To know the specific/default directory, you try running the above code with simply the name of your file (i.e. 'OCN04.txt'). The error message will show the file path. Save your txt file in that directory and try running your code again.

The above method works for me.

Answer 2

On DBeaver you can import data from file into a table with the Gui.

Rigth-click on the table and select "import data" menu.

Import Data Capture

and select the file to import.