Unloading data without a configuration file
Use the dsbulk unload command to unload database table rows to a CSV or JSON file.
To unload data from an Astra DB database, you must specify the path to the database’s secure connect bundle.
Unload data from a database to a CSV or JSON file
Specify the database’s keyspace ks1 and table table1 from which to unload the data to a CSV/JSON file.
Examples:
-
Astra DB
-
DSE, HCD, and Cassandra
dsbulk unload -url myData.csv -k ks1 -t table1 \
-b "path/to/secure-connect-database_name.zip" -u database_user -p database_passworddsbulk unload -url myData.csv -k ks1 -t table1The url value can designate a path on the local filesystem or a valid URL.
Unload graph data from a vertex table to a CSV file
Unload graph data from graph1 and table vertex_label1 to a CSV file.
This method only applies to HCD and DSE.
dsbulk unload --schema.graph graph1 --schema.vertex vertex_label1 \
-delim '|' > unloaded_person_data.csv