Docs Menu

Docs HomeMongoDB Atlas

Query with SQL

Note

Preview

The support for SQL queries is available as a Preview feature. This feature and the corresponding documentation may change at any time during the Preview phase.

You can query your federated database instance using Atlas SQL. This capability allows you to create SQL queries to visualize, graph, and report on your Atlas data using relational business intelligence tools such as Tableau.

Note

Atlas SQL only supports reading through Atlas Data Federation.

The SQL interface is available by default when you create a federated database instance. Atlas Data Federation automatically creates collection schemas for SQL query compilation and type inference.. To learn more about the schema, see Schema Management.

To run queries using the SQL interface, connect using the MongoDB JDBC Driver or one of the BI tool Named Connectors. To learn more about the different connect options, see Connect.

MongoDB Atlas SQL query flow diagram

The SQL interface includes the following components:

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 SQL queries between your BI tool and your Atlas data.

The JDBC Driver or a Named Connector provides a standard method to connect to a BI tool. Depending on what your BI tool supports, you can use JDBC or a specific Named Connector.

A visualization and reporting tool, such as Tableau.

←  Query a Federated Database InstanceGet Started →
Share Feedback
© 2022 MongoDB, Inc.

About

  • Careers
  • Investor Relations
  • Legal Notices
  • Privacy Notices
  • Security Information
  • Trust Center
© 2022 MongoDB, Inc.