You can run SQL-style queries to search data on your federated database instances using the SQL Interface. This capability allows you to visualize, graph, and report on your Atlas data using relational business intelligence tools such as Power BI and Tableau.
Note
Considerations
SQL Interface only supports read operations. You cannot write data to your Atlas cluster with the SQL Interface.
Important
MongoDB Minimum Version
If some or all of your data comes from an Atlas cluster, you must use MongoDB version 5.0 or greater for that cluster to take advantage of MongoSQL.
The SQL Interface is available by default when you create a federated database instance. Atlas Data Federation automatically creates collection schemas for MongoSQL query compilation and type inference. To learn more about the schema, see Schema Management.
To use the SQL Interface to run SQL queries, connect to your data using a MongoDB SQL Driver or one of the BI tool custom connectors. To learn more about the different connection options, see Connect.
Components
The SQL Interface includes the following components:
Federated Database Instance
A federated database instance is a deployment of Atlas Data Federation. Each federated database instance contains virtual databases and collections that map to data in your data stores. This also provides a SQL schema and translates MongoSQL queries between your BI tool and your Atlas data.
Custom Connector or SQL Driver
A custom connector or a SQL driver provides a standard method to connect to a BI tool. If you are using a BI tool, check which connections it supports.
BI Tool
A visualization and reporting tool, such as Power BI or Tableau.
Pricing
Querying your federated database instance with MongoSQL incurs data transfer charges. See Data Federation Costs to learn more about the costs associated with Atlas Data Federation.
Get Started
To start querying your Atlas data with MongoSQL, enable the SQL Interface and connect to your data with a driver or BI tool of your choice.