Connect to SQL Workbench/J

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

Note

This article covers SQL Workbench/J, which is neither provided nor supported by Databricks. To contact the provider, see use the SQL Workbench/J support forum in Google Groups..

Requirements

• SQL Workbench/J.

• A cluster or SQL warehouse in your Databricks workspace.

  • Create a cluster.

  • Configure SQL warehouses.

• The connection details for your cluster or SQL warehouse, specifically the Server Hostname, Port, and HTTP Path values.

  • Get connection details for a cluster.

  • Get connection details for a SQL warehouse.

• A Databricks personal access token.

  Note

  As a security best practice, when you authenticate with automated tools, systems, scripts, and apps, Databricks recommends that you use personal access tokens belonging to service principals instead of workspace users. To create tokens for service principals, see Manage tokens for a service principal.

Steps to connect to Workbench/J

To connect to Workbench/J, do the following:

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 directory where you downloaded the Simba Spark JDBC driver JAR.

   3. Verify that the Classname field is populated.

      

   4. Click OK.

4. Click the Create a new connection profile 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 1.

   4. In the Username field, enter token.

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

      

   6. Click Test.

      

   7. Click OK twice.

Additional resources

• SQL Workbench/J

• Support