Importing a CSV into a database using DBeaver Part 2

2018-08-12 1 min read Analyst

Forward

This is a followup to my previous post. My previous post demonstrated how to import a CSV using Dbeaver’s database to database export & import feature. As of version 5.1.5 Dbeaver introduced a direct CSV option for importing CSVs.

0) Install DBeaver

You can find installation instructions here

1) Connect to your target database

1.1) Navigate through your target database & schema and right click on your target table and select import table data

import_table_data

1.2) Next select CSV from the list

select_csv_option

1.3) Select your CSV file for upload

select_csv_table

2) Ensure that the mappings of each of your columns is correct

For column names that are an exact match DBeaver will automatically map them for you
For the remaining columns make sure to map the source columns to your desired target columns

map_columns

3) Complete the wizard and watch DBeaver import your data

Note: For large files it may be necessary to go get lunch but in my case 4 records doesn’t take long to import :)

data_finished

4) Check to make sure that the data has loaded correctly

As a last optional step it is good practice to make sure that everything loaded correctly which can easily be done by running a query against your target DB

data_in_table

SQL DBeaver CSV