AWS DMS CDC task with Mongodb as source fails

Question

Data migration tasks fails even after making all the changes in mongo db. 
Have created a role and user in the database I am using (non-root user account).
But the changestream seems to be not working correctly.

```
Encountered an error while initializing change stream: 'not authorized on admin to execute command .....
```
The endpoint connection is successful.
Please let me know what I am missing.

subhashr · Answer

this could be due to missing permission to initialize change stream. 
More specifically this is for source mongodb 4.x onwards 
please refer to section which tells how to create a role with that permission and also how to assign the same to dms user.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MongoDB.html#:~:text=Permissions%20needed%20when%20using%20MongoDB%20as%20a%20source%20for%20AWS%20DMS

AWS DMS CDC task with Mongodb as source fails

Relevant content