DBeaver

You can use the legacy Dremio JDBC driver to run SQL from DBeaver to explore your data in your data lakes and relational databases through Dremio.

Supported Versions

You can use any version of DBeaver, if you use the legacy Dremio JDBC Driver 14.0.0 or later.

Supported Authentication Methods

You can use your Dremio username and password, or you can use a personal access token (PAT) that you obtained from Dremio.

Prerequisites

• Download the legacy Dremio JDBC driver.
• If you want to authenticate your connection to Dremio by using a personal access token, see Creating a PAT for the steps to obtain one.

Connecting to Dremio

1. In DBeaver, select Database > New Database Connection.

2. Search for "Dremio", then select it and click Next.

3. In the Connect to a database dialog, click Edit Driver Settings.

4. On the Settings page of the Edit Driver 'Dremio' dialog, change the defaults for the JDBC connection URL:

   a. In the URL Template field, replace the current template with either of these:

   • If you are not using ZooKeeper: jdbc:dremio:direct={host}[:{port}]
   • If you are using ZooKeeper: jdbc:dremio:zk={host}[:{port}]

   b. In the Default Port field, set the value to 31010.

5. On the Libraries page of the Edit Driver 'Dremio' dialog, add the .jar file to the driver library:

   a. Delete any entry that might already be listed.

   b. Click Add File and select the Dremio's JDBC driver that you downloaded.

6. Click OK.

7. In the Host field on the Main page of the Connect to a database dialog, specify the hostname of your coordinator node.

8. To provide your authentication credentials, follow either of these steps:

   • To use a personal access token that you obtained from Dremio:
     1. In the Username field, specify the username for which the PAT was generated.
     2. In the Password field, paste your personal access token.
   • To use your Dremio username and password:
     1. In the Username field, specify your username.
     2. In the Password field, your password.

9. If you are using TLS encryption for connections to Dremio, turn on encryption for the driver:

   a. Click Driver properties.

   b. Under the list of properties, click the "Add user property" icon.

   c. Name the property ssl and set the value to true.

   d. Click Main to return to the Main page of the dialog.

10. (Optional) Click Test Connection. If the connection works, the Connection Test dialog opens and indicates that DBeaver is able to connect to Dremio. The connection is not held open. Click OK.

11. Click Finish.