Skip to main content

DbVisualizer

DbVisualizer is a SQL runner that works with any JDBC-compliant data source. You can run SQL from it to explore your data in your data lakes and relational databases through Dremio and the Arrow Flight SQL JDBC driver.

Supported Authentication Methods​

  • Use a personal access token (PAT) obtained from Dremio. To create a PAT, follow the steps in Create a PAT.

  • Use Microsoft Entra ID as an enterprise identity provider. To configure Microsoft Entra ID, see Microsoft Entra ID.

    note

    You can use Microsoft authentication only if the admin for your Dremio organization has enabled it.

Prerequisites​

  • Download the Arrow Flight SQL JDBC driver.
  • If you do not want to connect to the default project in your Dremio organization, copy the ID of the Dremio Cloud project that you want to connect to. See Obtain the ID of a Project for the steps. After you obtain it, save it somewhere that you can retrieve it from during the procedure.

Connecting to Dremio​

  1. Add the Arrow Flight SQL JDBC driver to DbVisualizer's Driver Manager. You need to do this only once, and can skip this step if DbVisualizer already lists this driver in its Driver Manager dialog:

    a. Select Tools > Driver Manager.

    b. Above the Driver Name list of the Driver Manager dialog, click the plus (+) symbol.

    c. In the Name field, name the driver.

    d. Under Driver artifacts and jar files, click the plus icon, browse to the .jar file that you downloaded, select it, and click Open. DbVisualizer loads the .jar file.

    e. Close the Driver Manager dialog.

  2. Create a connection to Dremio:

    a. In the menubar, select Database > Create Database Connection.

    b. Double-click Custom at the bottom of the Driver Name list.

    c. Name the connection.

    d. In the Settings Format field, select Database URL.

    e. Click in the Driver Type field and then double-click the name that you gave to the Arrow Flight SQL JDBC driver.

    f. In the Database URL field, specify a URL in this format, replacing <encoded_pat> with your URL-encoded personal access token:

    jdbc:arrow-flight-sql://data.dremio.cloud:443/?token=<encoded_pat>

    If you want to connect to a non-default project, append &catalog=<project_id>, replacing <project_id> with the ID of your project:

    jdbc:arrow-flight-sql://data.dremio.cloud:443/?token=<encoded_pat>&catalog=<project_id>

    To URL-encode your PAT, see URL-encoding Values.

    g. (Optional) Click Ping Server to test the connection.

    h. Click Connect.

DbVisualizer creates the connection and opens it.