Unloading data without a configuration file
Unload CSV data with a dsbulk unload command.
Unload CSV or JSON data with a
dsbulk unload command.Important: To
unload data into 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 Providing access to Astra databases.Unload data from an external file
Specify the external file to write the data to from keyspace ks1 and table table1:
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_password
DSE / Open source Apache Cassandra® databases
dsbulk unload -url myData.csv -k ks1 -t table1
The url value can designate a path on the local filesystem or a valid URL.
Unload CSV data from a graph vertex label table to a CSV file
Unload graph data as a CSV file from the graph graph1 and table vertex_label1.
DSE databases
dsbulk unload --schema.graph graph1 --schema.vertex vertex_label1 \ -delim '|' > unloaded_person_data.csv