On this page

    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:

    FieldValue
    NameDremio
    URL Format (direct)jdbc:dremio:direct=${Server}:${Port|31010}
    URL Format (ZooKeper)jdbc:dremio:zk=${Server}:${Port|2181}
    Driver Classcom.dremio.jdbc.Driver
    Driver File Pathsdremio-jdbc-*version*.jar

    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:

    FieldValue
    NameAny name
    DriverDremio
    Database ServerThe hostname or IP address of any node in the Dremio cluster
    Database Port31010
    Database UseridYour username
    Database PasswordYour password

    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 an SQL Query

    From the SQL Commander menu, select New SQL Commander. You can now run your first SQL query.