Docs Menu

Set Up and Query Data Federation

Seamlessly query, transform, and aggregate data from one or more MongoDB Atlas databases, AWS S3 buckets, Azure containers, and Atlas Data Lake datasets. Get the insights you need or get the data into the hands of those who need it!

Get Started

Learn More About Atlas Data Federation

MongoDB Atlas Data Federation landing page hero image
What You Can Do

Data Federation provides the capability to federate queries across data stored in various supported storage formats, including Atlas clusters, Atlas Online Archives, Data Lake Datasets, AWS S3 Buckets, and HTTP Stores. You can derive insights or move data between any of the supported storage formats of the service.


Use the wizard to create a federated database instance and connect the Atlas cluster collections you want as data sources.

See Use the Feed Downstream Systems Wizard.


Provide credentials to your cloud object storage, authorizing your federated database instance to export data to it.


Write data from your Atlas cluster to your cloud object storage in Parquet, CSV, BSON, or MongoDB Extended JSON on a schedule using MongoDB's $out operator.

MongoDB Atlas Data Federation query federated databases image

Use the wizard to create a federated database instance using IP Access Lists or Private Link. Use your database username and password or X.509 for authentication.

See Use the Query Data Across Clusters Wizard.


Connect entire databases or specific collections from any or all your Atlas clusters.


Connect and query using any MongoDB-compatible tool, including SQL tools that use the MongoDB JDBC Driver or Tableau Connector.

See Run Queries Against Your Federated Database Instance.

MongoDB Atlas Data Federation query across clusters configuration image

Head over to Atlas Data Lake and create a Data Lake pipeline from an Atlas cluster collection.

See Create a Data Lake.


Create virtual collections in your federated database instance sourcing data from your newly created Data Lake dataset.

See Configuration for Data Lake Datasets.


Connect your favorite native MongoDB Query Workbench like Compass or connect any SQL-native workbench using the MongoDB JDBC driver.

See Connect with Compass.

MongoDB Atlas Data Federation Data Lake datasets mapping image
Related Products & Resources

Follow the tutorials below to get a headstart on solving your most pressing challenges!

MongoDB Atlas Data Federation icon for exporting data

Export data from your Atlas Cluster to Parquet files

Follow the tutorial

MongoDB Atlas Data Federation icon for querying Atlas DBs

Query across data from multiple Atlas clusters

Query multiple databases

MongoDB Atlas Data Federation icon for sandbox

Learn from a walkthrough and query your own data in a sandbox

Try it in a sandbox