DBeaver
DBeaver is a SQL runner that works with any JDBC-compliant data source.
Prerequisites
Download the Dremio JDBC driver.
Create a New Driver
Select Driver Manager from the Database menu and create a new driver with these settings:
Field Value Driver Name Dremio
URL Template (direct) jdbc:dremio:direct={host}[:{port}][;schema={database}]
URL Template (ZooKeeper) jdbc:dremio:zk={host}[:{port}][;schema={database}]
Class Name com.dremio.jdbc.Driver
Driver Type Generic
Default Port 31010
Driver File Paths dremio-jdbc-*version*.jar
Click Add File and select the location of the Dremio JDBC driver.
Create a Connection
Click Create New Connection and select Dremio.
Specify your coordinator node’s hostname, username and password.
Now you can use DBeaver’s SQL Editor to execute queries to your Dremio datasets.
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.