This article describes how to use SQL Workbench/J with Databricks.
Get a personal access token.
As a security best practice, when authenticating with automated tools, systems, scripts, and apps, Databricks recommends you use access tokens belonging to service principals instead of workspace users. For more information, see Service principals for Databricks automation.
Get the server hostname, port, and HTTP path.
Launch SQL Workbench/J.
Select File > Connect window.
In the Select Connection Profile dialog, click Manage Drivers.
In the Name field, type
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.
Verify that the Classname field is populated.
Click the Create a new connection profile icon.
Type a name for the profile.
In the Driver field, select com.simba.spark.jdbc.Driver.
In the URL field, enter the URL you constructed in Step 1.
In the Username field, enter
In the Password field, enter your personal access token from Step 1.
Click OK twice.