Unloading data without a configuration file
Unload database rows with a dsbulk unload command to CSV/JSON files.
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
dsbulk unload -url myData.csv -k ks1 -t table1 \
-b "path/to/secure-connect-database_name.zip" -u database_user -p database_passwordDSE and Cassandra
dsbulk 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.
DSE
dsbulk unload --schema.graph graph1 --schema.vertex vertex_label1 \
-delim '|' > unloaded_person_data.csv