MongoDB Atlas
Connect a MongoDB Atlas cluster with a connection string. Collections become datasets; documents are flattened into rows.
Reads collections from a MongoDB Atlas cluster. Each collection is a dataset, and documents are flattened into rows (nested fields become dot-notation columns) with columns inferred by sampling. Flitch only reads, so use a database user with read access.
Add a source
Atlas connects with a connection string (the SRV URI, which carries the host and credentials).
Prerequisites
- A MongoDB Atlas cluster.
- A database user with read access to the collections you want.
Create a read-only user
In Atlas → Database Access → Add New Database User, create a user and grant the built-in Only read any database (or a custom role with read on your database).
Copy the connection string
In Atlas → Connect → Drivers, copy the SRV string:
mongodb+srv://flitch_readonly:password@cluster.mongodb.netOpen the form
Go to Data → Add → MongoDB Atlas, paste the connection string, enter the database name, then pick collections.
Network access
Flitch connects from its own server, not your browser. Add Flitch's connector egress IP (shown in the Add Source form) under Atlas → Network Access → IP Access List. (Allowing access from anywhere works too but is less secure.)
How documents map to rows
- Each collection is a dataset; each document is a row.
- Nested objects become dot-notation columns (e.g.
address.city); arrays are kept as JSON. ObjectId,Date, and other BSON types are converted to plain strings/numbers.- Columns are inferred by sampling documents, so collections with very different document shapes may show a sparse column set.
Refresh
Refresh is off by default. Enable it to schedule a background refresh and serve from cache between runs. See Refresh.
Disconnect
Delete the connection from Data. Dashboards built from it keep their last cached data until you remove them.
Troubleshooting
Authentication failed. Check the username and password in the connection string, and that the user has read access to the database.
Connection timed out. Verify the connector egress IP is allowlisted under Atlas → Network Access.
No collections shown. Confirm the database name is correct and the user can list collections on it.
MongoDB
Connect a MongoDB database or Atlas cluster with a connection string. Collections become datasets; documents are flattened into rows.
Amazon DocumentDB
Connect an Amazon DocumentDB cluster (MongoDB-compatible) with a connection string. Collections become datasets; documents are flattened into rows.