Amazon DocumentDB Error: Unable to Connect to Database - No Instance with Change Stream Access Found

Issue

The connection setup test may fail with the following error:

• Unable to connect to database - No instance with change stream access found.

Environment

Connector: Amazon DocumentDB

Resolution

To resolve this issue, enable change streams for every collection you want to sync and provide at least one database instance that can read them. For Amazon DocumentDB versions below 5.0, provide the primary instance because secondary instances cannot read change streams. For more information, see our Amazon DocumentDB Setup Guide.

Cause

This issue occurs when Fivetran fails to connect to at least one database instance that has change streams enabled. To perform incremental updates from your Amazon DocumentDB source, we use change streams. We verify change stream access for at least one collection to capture data changes.