Amazon RDS (MySql) export to s3 - Is there any way to provide partition keys to each for the tables so that the S3 data falls into these dynamic partitioned folders created for each table within DB

A glue ETL job can do that for you .

1. Read the DMS data
2. Write the data back to a different S3 bucket based on your partition keys .
3. Loop it for each table through a Glue Python job

On the high level its a 2 step process , minimal coding , use DynamicFrames which will also help you in clubbing multiple CDC files into larger chunks improving better reads on the consuming applications .

Please note

1. Glue will incur costs
2. Its not going to be real time as DMS , since additional read and writes are involved
3. DMS will result in multiple versions of the record , For example , Inserts , Multiple Updates and Delete . You can handle that in Glue, but the program will have a few more steps then. This is based on your requirement though

was this solution implementeD?