SQL Workbench/J

This article describes how to use SQL Workbench/J with Databricks.

Step 1: Download and install software

Download and install the following:

Step 2: Get Databricks connection information

  1. Get a personal access token.
  2. Get your cluster’s JDBC URL using the instructions in Server hostname, port, HTTP path, and JDBC URL.

Step 3: Configure connection in Workbench/J to a Databricks cluster

  1. Launch SQL Workbench/J.

  2. Select File > Connect window.

  3. In the Select Connection Profile dialog, click Manage Drivers.

    1. In the Name field, type Spark JDBC.

    2. In the Library field, click the Select the JAR file(s) icon. Browse to the the directory where you downloaded the Simba Spark JDBC driver JAR.

    3. Verify that the Classname field is populated.

      Spark JDBC driver
    4. Click OK.

  4. Click the Create a new connection profile Connection Profile Icon icon.

    1. Type a name for the profile.

    2. In the Driver field, select com.simba.spark.jdbc.Driver.

    3. In the URL field, enter the URL you constructed in Step 2.

    4. In the Username field, enter token.

    5. In the Password field, enter your personal access token from Step 2.

      Connection profile
    6. Click Test.

      Connection test
    7. Click OK twice.