CSV

Importing a CSV into a database using DBeaver Part 2

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

Importing a CSV into a database using DBeaver

Update: August 12, 2018 The following post demonstrates how to import CSVs using Dbeaver’s database to database export & import feature. If you are certain of the quality of your CSV & just want to import it quickly my subsequent post may be more useful. 0) Install DBeaver You can find installation instructions here 1) Create a folder to be used as your CSV Database mkdir ~/desktop/csvs Place the CSV you want to load into this folder