Dbeaver Cassandra

Dark theme support was improved (Windows 10 and GTk)
Data viewer:
- Copy As: format configuration editor was added
- Extra configuration for filter dialog (performance)
- Sort by column as fixed (for small fetch sizes)
- Case-insensitive filters support was added
- Plaintext view now support top/bottom dividers
- Data editor was fixed (when column name conflicts with alias name)
- Duplicate row(s) command was fixed for multiple selected rows
- Edit sub-menu was returned to the context menu
- Columns auto-size configuration was added
- Dictionary viewer was fixed (for read-only connections)
- Current/selected row highlighting support was added (configurable)
Metadata search now supports search in comments
GIS/Spatial:
- Map position preserve after tiles change
- Support of geometries with Z and M coordinates was added
- Postgis: DDL for 3D geometry columns was fixed
- Presto + MySQL geometry type support was added
- BigQuery now supports spatial data viewer
- Binary geo json support was improved
- Geometry export was fixed (SRID parameter)
- Tiles definition editor was fixed (multi-line definitions + formatting)
SQL editor:
- Auto-completion for objects names with spaces inside was fixed
- Database objects hyperlinks rendering was fixed
SQL Server: MFA (multi-factor authentication) support was added
PostgreSQL: array data types read was fixed
Oracle: indexes were added to table DDL
Vertica: LIMIT clause support was improved
Athena: extra AWS regions added to connection dialog
Sybase IQ: server version detection was improved
SAP ASE: user function loading was fixed
Informix: cross-database metadata read was fixed
We migrated to Eclipse 2021-03 platform

Forward

DBeaver is free universal SQL client/database tool for developers and database administrators. It can work with any database server which has JDBC or ODBC driver. It supports pluggable extensions. EclipseCon Europe 2018 Ludwigsburg, Germany October 23 - 25, 2018Tatiana Krupenya (dbeaver.com)Serge Rider. Data viewer and editor. Multiple data views to fit the variety of users’ needs, for example display of image contents (gif, png, jpeg, bmp) as an images. Editing of data inline and in a dedicated space. Convenient navigation among data. Custom filters for table contents. Check out popular companies that use DBeaver and some tools that integrate with DBeaver. PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. DBeaver is a tool in the Database Tools category of a tech stack. DBeaver is an open source tool with 20K GitHub stars and 1.9K GitHub forks.

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

1.2) Next select CSV from the list

1.3) Select your CSV file for upload

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

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 :)