AWS DMS replicate only selected columns
I'm using AWS DMS to CDC from MySQL on-premise database to AWS S3.
- Is it feasible to transfer only a few columns from the source table to target? I have a table with more than 50 columns and only need 10.
- If I want to transfer 5 tables from the source, is it best practice to create 1 replication task for each table, or put all 5 in one?
-
You can do that by creating filter conditions. This video will help you out.
-
That is totally up to you. No matter how replication tasks are created, it works normally. If your tables are so different from each one, you can consider separating them.
-
Yes, by using transformations.
-
If your replication tasks are full-load-and-cdc, then, definitely no. Because each replication task will end up with the redo logs being transferred to your replication instance, consuming memory CPU power, and network bandwidth.