This step-by-step tutorial guides you through migrating data from Apache Cassandra to
Amazon Keyspaces using the DataStax Bulk Loader (DSBulk) available on GitHub
Prerequisites – Set up an AWS account with credentials, create a JKS trust store file for the
certificate, configure cqlsh, download and install DSBulk, and configure an application.conf file.
Create source CSV and target table – Prepare a CSV file as the source data and create the target keyspace and table in Amazon Keyspaces.
Prepare the data – Randomize the data in the CSV file and analyze it to determine the average and maximum row sizes.
Set throughput capacity – Calculate the required write capacity units (WCUs) based on the data size and desired load time, and configure the table's provisioned capacity.
Configure DSBulk settings – Create a DSBulk configuration file with settings like authentication, SSL/TLS, consistency level, and connection pool size.
Run the DSBulk load command – Run the DSBulk load command to upload the data from the CSV file to the Amazon Keyspaces table, and monitor the progress.
Topics
Prerequisites: Steps you have to complete before you can upload data with DSBulk
Step 1: Create the source CSV file and a target table for the data upload using DSBulk
Step 4: Configure DSBulk settings to upload data from the CSV file to the target table
Step 5: Run the DSBulk load command to upload data from the CSV file to the target table
