DMS: Source filters are not currently supported for MongoDB

Question

Hello Team,

We are trying to migrate EC2 based Mongo DB to AWS Document DB. We are able to migrate with DMS with Full Load. We have 81M records but we don't want all the data so we need to apply filter to limit the record count. 
We are getting below error when apply filter for source. Are we not supporting source filters for MongoDB. Can you please confirm.

SYSTEM ERROR MESSAGE:Error in mapping rules. Rule with ruleId = 311929325 failed validation. Source filters are not currently supported for MongoDB

Answer

Hi there!

As of 6/9/2023, source filters are not supported when selecting MongoDB as a source in DMS. This is a documented [limitation](https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MongoDB.html#CHAP_Source.MongoDB.Limitations) in the service.

There doesn't seem to be a workaround currently. :(

My best guess is that you will need to migrate all the data and then delete the unwanted rows.

I hope this helps.

DMS: Source filters are not currently supported for MongoDB

Relevant content