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

Flexibility for Your Data

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.

Connect Your Atlas Cluster as a Data Source

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.

Connect Your Destination Object Store

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

Specify the Export Frequency and Format

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

Configure Your Federated Database Instance

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.

Choose Collections Across Clusters

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

Query Using Your Favorite Tools

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

Create a Data Lake Pipeline

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

See Create a Data Lake.

Map to Virtual Collections

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

See Configuration for Data Lake Datasets.

Query with MongoDB Compass

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

Tutorials to get you started!

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

Export data from your Atlas Cluster to Parquet files

Follow the tutorial

Query across data from multiple Atlas clusters

Query multiple databases

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

Try it in a sandbox