DBeaver
You can 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 for Linux, MacOS, or Windows, except for version 23.0.2.202304091457.
Supported Authentication Method
Authenticate to Dremio Cloud by using a personal access token. To create one, see Creating a Token.
Prerequisites
-
Download the JDBC driver for Arrow Flight SQL.
-
For MacOS, ensure you have the latest version of Java Runtime Environment (JRE).
Connecting to Dremio
Step 1: Add the JBDC Driver
You only need to add the JDBC driver for Arrow Flight SQL once. You can skip this step if DBeaver already lists this driver in its Driver Manager dialog. To add the JDBC Driver, follow these steps:
-
In the menubar, select Database > Driver Manager.
-
In the Driver Manager dialog, click New.
-
In the Settings section, follow these steps:
-
In the Name field, specify a name for the driver, such as "JDBC Driver for Arrow Flight SQL".
-
In the Driver Type field, ensure that Generic is the selected driver type.
-
In the Class Name field, specify
org.apache.arrow.driver.jdbc.ArrowFlightJdbcDriver
. -
In the URL Template field, specify
jdbc:arrow-flight-sql://data.dremio.cloud:443/
. -
In the Default Port field, specify
443
.
-
-
In the Libraries section, click Add File and select the
.jar
file for the JDBC driver for Arrow Flight SQL. -
Click OK.
Step 2: Create a Connection
Once you've added the JBDC Driver for Arrow Flight SQL, follow these steps to create a connection to Dremio:
-
Select Database > New Connection from JDBC URL.
-
In the dialog that follows, enter
jdbc:arrow-flight-sql://data.dremio.cloud:443/
. At this point, DBeaver lists the driver in the Drivers field. If the driver is not immediately suggested, type and then delete a character in the input field to refresh suggestions. -
Select the JBDC driver and click Next.
-
In the Connect to a Database dialog, follow these steps:
-
Select URL as the value for Connect By.
-
In the JDBC URL field, append
?token=<encoded_pat>
to the URL and replace<encoded_pat>
with your URL-encoded personal access token.noteIf connecting to a non-default project, you must also append
&catalog=<project_id>
to the URL and replace<project_id>
with your project ID. -
(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.
-
-
Click Finish.