The support for SQL format queries is available as a Beta feature. The feature and the corresponding documentation may change at any time during the Beta stage.
You can use the JDBC driver to connect to Atlas Data Lake and run SQL format queries on your Data Lake collections and views. The JDBC driver can be used to connect a Java application like a Maven project or a visualization tool like Tableau. To run SQL format queries, your collections or views must already have the relational schema set. See Querying with SQL to learn more about automatically or manually generating and setting schemas for your collections and views.
This page describes how to install and configure the JDBC driver for connecting to Atlas Data Lake.
To connect with your Maven application:
- Click on the JDBC driver version in the JDBC Driver download page to open the JDBC Driver page for that version.
Click the copy icon in the Apache Maven on the right-hand side to copy the dependency.
You can only connect to one database at a time. To query multiple databases, you must create multiple connections or fully specified SQL queries. When you use the JDBC driver to connect to Atlas Data Lake with Tableau, you can only connect to the database specified in your properties file.
Download the MongoDB Atlas Data Lake JDBC driver JAR file and all associated dependencies by selecting
all.jar from the dropdown list in the Download column.
To connect with Tableau, create a properties file with the following settings:
user=<database-user> password=<database-user-password> authSource=admin database=<database-to-query> ssl=true compressors=zlib
Username of the database user in your Atlas cluster.
Password of the database user in your Atlas cluster.
Authentication database of the database user in your Atlas cluster, which is always
Database in the Atlas cluster that contains the data to query.
When you use the JDBC driver to connect Tableau to Atlas Data Lake, you can only connect to the database specified here.
Whether format of the query is SSL. Value must be
File compression format. Value must be
Specify your Data Lake URL in the following format:
To construct the URL:
Select MySQL from the drop-down.
Click Browse and select the properties file to use for this connection.
You can leave the Username and Password fields empty if you specified them in the properties file.