I would like to use AWS DMS to replicate changes from transactional on-premise MySQL database to AWS S3. Afterward, that data would be moved to Snowflake datamart.
The problem I'm facing, how can I start the replication task manually, let's say every 6 hours, and transfer to S3 only changes during that period. Then, I would load data into Snowflake and move(remove) loaded files so the landing area path is empty and ready for the new 6 hours batch.
