Docs Home → Launch & Manage MongoDB → MongoDB Atlas
Advanced Configuration
On this page
This page guides you through setting up your own federated database instance and importing sample data.
Prerequisites
A MongoDB database user with which to connect.
Create a Federated Database Instance
To create a federated database instance and map it to sample data:
Go to to your federated database instance.
If it isn't already displayed, click Data Federation in the sidebar.
Click Create Federated Database Instance.
If you have an existing federated database instance, instead click Create Federated Database in the top right corner of the dashboard.
Connect to a Data Source and add sample data to your federated database instance.
You can use a sample dataset to start exploring Atlas SQL through Atlas Data Federation without configuring a data source yourself. This tutorial references a specific sample dataset.
Note
To connect to your own data instead, click Add Data Sources. To learn more about configuring different types of data sources, see Define Data Stores for a Federated Database Instance.
If you want to configure data from a Atlas cluster, you must use MongoDB version 5.0 or greater for that cluster to take advantage of Atlas SQL.
Click Add Sample Data.
Select
AWS S3from the Filter dropdown if it isn't selected already.Expand the S3 store
sample-data-atlas-data-lakeif it isn't expanded already.
For this tutorial, configure your federated database instance as follows using the Federated Database Instance panel:
Rename the default collection.
Click next to the default collection
VirtualCollection0 to edit its name. For this tutorial,
rename your collection Sessions.
Create a second collection.
Click next to the default name
VirtualDatabase0 to add a collection to the database.
For this tutorial, name your new collection Users.
Add data to your virtual database.
Drag and drop the following data sources into the respective federated database instance virtual collections:
/mflix/sessions.json, into theSessionscollection, and/mflix/users.jsoninto theUserscollection.
Click Save.
Your federated database instance appears on the Data Federation page.
To learn more about configuring Atlas Data Federation with real data stores, see Define Data Stores for a Federated Database Instance.
Connect to Your Federated Database Instance
To connect to your federated database instance and query sample data or your own data with Atlas SQL, see Connect.
For a tutorial on connecting with free tools, see Connect to and Query Data with Free SQL Tools.