Unable to use JDBC/ODBC url with sql workbench

User16753724663
Databricks Employee
Databricks Employee

‎06-16-2021 10:00 AM - last edited on ‎03-21-2025 05:54 AM by Community Manager

 

SQL Workbench is not able to connect to Cluster using JDBC/ODBC connection. Getting the following error. I used the configuration provided by the cluster (jdbc:spark://<host>.cloud.databricks.com:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/4209149124889478/0305-185803-tam450;AuthMech=3)

 

[Simba][SparkJDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 401, Error message: Unknown. [SQL State=08S01, DB Errorcode=500593]

Labels:
0 Kudos

User16753724663
Databricks Employee
Databricks Employee

‎06-16-2021 10:01 AM

As we are getting 401 error that means an authentication issue. We should use Personal access token for password.

The username should be "token" and the password should be PAT token.

0 Kudos