By using AWS re:Post, you agree to the Terms of Use

Applying column filters in DMS Task for source MongoDB and target Postgres

0

In my AWS DMS Task Source - MongoDB Target - RDS Postgres SQL

I am able to apply column filter and only 3 selected columns gets migrated to target.

But if source mongo document contains an object datatype. So In Include-column filter after specifying

  • oid__id
  • phone_no
  • address
  • Params.name
  • Params.age

Only top two columns oid__id, address and phone_no gets migrated to target remaining two column is skipped by DMS task.