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 a cloud-based DataStax Astra database, specify the path to the secure connect bundle ZIP file.
It contains the security certificates and credentials for your database.
Also specify the username and password entered when creating the database.
For information about downloading the secure connect bundle ZIP via the Astra console, in advance of entering the dsbulk command, refer to Obtain database credentials.
|
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:
DataStax Astra databases
dsbulk unload -url myData.csv -k ks1 -t table1 \
-b "path/to/secure-connect-database_name.zip" -u database_user -p database_passwordDSE / Open source Apache Cassandra® databases
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 databases
dsbulk unload --schema.graph graph1 --schema.vertex vertex_label1 \
-delim '|' > unloaded_person_data.csv