Skip to main content

DBeaver (with the Legacy Dremio JDBC Driver)

You can run SQL from DBeaver to explore your data in your data lakes and relational databases through Dremio Cloud.

Supported Versions

You can use any version of DBeaver, as long as you use Dremio JDBC Driver 14.0.0 or later.

Supported Authentication Methods

You can use your Dremio Cloud username and password, or you can use a personal access token.

Prerequisites

  • Download the legacy Dremio JDBC Driver.

    note

    Dremio recommends that you use the JDBC driver for Arrow Flight SQL. See the instructions for using that driver with DBeaver here.

  • Copy the ID of the Dremio Cloud project that you want to connect to. See Obtaining the ID of a Project for the steps. After you obtain it, save it somewhere that you can retrieve it from during the procedure.

  • If you want to authenticate your connection to Dremio Cloud by using a personal access token, see Creating a Token for the steps to obtain one. After you create a token, save it somewhere that you can retrieve it from during the procedure.

Creating a Connection

  1. Launch DBeaver.

  2. Select Database > New Database Connection.

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

  4. Click Edit Driver Settings.

  5. In 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 this one:

    URL template
    jdbc:dremio:direct={host}[:{port}][;ssl=true;PROJECT_ID={database}]

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

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

  7. Click OK.

  8. In the Host field, specify sql.dremio.cloud.

  9. In the Database/Schema field, paste the ID of the project that you want to connect to.

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

    • To use a personal access token that you obtained from Dremio Cloud:
      1. In the Username field, specify $token.
      2. In the Password field, paste your personal access token.
    • To use your Dremio Cloud username and password:
      1. In the Username field, specify your username.
      2. In the Password field, your password.
  11. Click Test Connection. If the connection works, the Connection Test dialog opens and indicates that DBeaver is able to connect to Dremio Cloud. The connection is not held open. Click OK.

  12. Click Finish.