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.