Migrate a SQL DB to NoSQL DB

You can migrate data to Amazon S3 using AWS DMS from any supported database source. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.S3.html

After that you can try tools like cqlsh https://docs.aws.amazon.com/keyspaces/latest/devguide/bulk-upload.html or DSBulk https://docs.aws.amazon.com/keyspaces/latest/devguide/dsbulk-upload.html

Amazon Keyspaces is a managed AWS service compatible with Apache Cassandra. The service is servlerless. I recommend that you will review this service if you would like to run a Cassandra workload on AWS. In order to migrate data from a relational database to Amazon Keyspaces, you can make use of the AWS Glue service. There are several relevant examples in this repository - https://github.com/aws-samples/amazon-keyspaces-examples/tree/main/scala/datastax-v4/aws-glue.