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.
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.
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.