DbVisualizer
DbVisualizer is a SQL runner that works with any JDBC-compliant data source.
Prerequisites
Download Dremio JDBC Driver.
Create a New Driver
From the Tools menu, select Driver Manager and create a new driver with these settings:
| Field | Value |
|---|---|
| Name | Dremio |
| URL Format (direct) | jdbc:dremio:direct=${Server}:${Port|31010} |
| URL Format (ZooKeper) | jdbc:dremio:zk=${Server}:${Port|2181} |
| Driver Class | com.dremio.jdbc.Driver |
| Driver File Paths | dremio-jdbc-*version*.jar |
The Driver window should look like this:
Note that you will need to select the JAR file before you can select the Driver Class from the drop-down menu.
Create a New Connection
From the Tools menu, select New Connection Wizard and follow the wizard to create the connection to your Dremio cluster with these settings:
| Field | Value |
|---|---|
| Name | Any name |
| Driver | Dremio |
| Database Server | The hostname or IP address of any node in the Dremio cluster |
| Database Port | 31010 |
| Database Userid | Your username |
| Database Password | Your password |
The New Connection Wizard should look like this:
Note that you can also create a new connection without using the wizard. The process is very similar, except that you will define the settings on a single window.
Execute a SQL Query
From the SQL Commander menu, select New SQL Commander. You can now run your first SQL query.