• Glossary
  • Support
  • Downloads
  • DataStax Home
Get Live Help
Expand All
Collapse All

DataStax Bulk Loader

    • About DataStax Bulk Loader
    • Release notes
    • Architecture
    • Installing
    • Getting Started
      • Loading data
      • Unloading data
      • Counting data in tables
      • Creating configuration files
      • Loading tables that contain static and non-static columns
      • Using SSL with dsbulk
      • Printing cluster information
    • Kerberos client authentication
    • Reference
      • dsbulk
        • Loading data examples
        • Unloading data examples
        • Counting data example
        • Exit codes
      • Common options
      • Connector options
      • Count options
      • Schema options
      • Batch options
      • Codec options
      • Driver options
      • Engine options
      • Executor options
      • Logging options
      • Monitoring options
  • DataStax Bulk Loader
  • Getting Started
  • Unloading data

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_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 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
Loading data Counting data in tables

General Inquiries: +1 (650) 389-6000 info@datastax.com

© DataStax | Privacy policy | Terms of use

DataStax, Titan, and TitanDB are registered trademarks of DataStax, Inc. and its subsidiaries in the United States and/or other countries.

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries.

Kubernetes is the registered trademark of the Linux Foundation.

landing_page landingpage