AWS DMS - Load data for last 7 days

0

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.

demandé il y a 2 ans597 vues
2 réponses
0

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 )

AWS
répondu il y a 2 ans
  • Thanks for the information but can you give example how to give the filter with specific date.

0

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.

AWS
vg
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions