AWS DMS - Load data for last 7 days


Hi There there a way in AWS DMS to only pull full load for only certain number of days e.g last 7 days. Is there any setting which can be added to achieve this. Thank you.

asked 3 months ago55 views
2 Answers

DMS wont have a way to get last 7 days of data.

unless there is a date column which could have this information.

you can do filter to bring data greater than specific date

please note DMS cannot do relative time data filtering (e.g. last 7 days or last 2 hours )

answered 3 months ago
  • Thanks for the information but can you give example how to give the filter with specific date.


If you have a date column in the source table that can identify the data for the last 7 days, you can create a task to filter the table based on that date.

answered 3 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions