axonops / axonops-workbench

AxonOps™ Workbench for Apache Cassandra® - Desktop application for Mac, Windows and Linux
https://axonops.com
Apache License 2.0
11 stars 0 forks source link

[feat] Support bulk import/export CSV from Cassandra tables #214

Open millerjp opened 3 months ago

millerjp commented 3 months ago

CQLSH has the abiliy to upload CSV to tables and download. https://cassandra.apache.org/doc/4.1/cassandra/tools/cqlsh.html#copy-to https://cassandra.apache.org/doc/4.1/cassandra/tools/cqlsh.html#copy-from

We need to provide a similar feature in Workbench using our buit in CQLSH binary

Users should be able to 1 - Browse to a CSV file and upload it to a Cassandra table on a cluster they are connected to 2 - Users should be able to right click on a table in tree view and download its data as CSV

When downloading to CSV provide a warning to the users if they want to do this as and the table has a lot of data - it could take some time and put load on the cluster. Display the warning text when downloading "Please note that when exporting a Cassandra table to CSV, if the table has a lot of data this may take some time and put load on your cluster"

We should also support the CQL commands in the AxonOps Console