cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

DBEAVER Connection to Sql Warehouse in Databricks

ADBQueries
New Contributor

I'm trying to connect to SQL warehouse in Azure Datebricks with DBEAVER application.

I'm creating a jdbc connection string as mentioned here: https://docs.databricks.com/en/integrations/jdbc/authentication.html

Here is a sample connection link I have created: 

JDBC Connection String:
jdbc:databricks://adb-3XXXXXXXXXXXXXX.XX.azuredatabricks.net:443;httpPath=/sql/1.0/warehouses/XXXXXXXXXXXXXXXX;AuthMech=3;UID=token;PWD=<PATTokenCreatedFromMyAccountOnDatabricks>

Here is a generic error that I'm Getting:
[Databricks][JDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: HTTP Response code: 403, Error message: Unknown.
  HTTP Response code: 403, Error message: Unknown
  HTTP Response code: 403, Error message: Unknown

1 REPLY 1

Ayushi_Suthar
Databricks Employee
Databricks Employee

Hi @ADBQueries , Good Day! 

Could you please try running the code again to generate another access token and, once generated, check it on this page, https://jwt.ms, to confirm that the token has not expired?

Also, if not done yet, please review the following discussions on this same error/issue:

https://stackoverflow.com/questions/76426385/databricksdatabricksjdbcdriver500593-communication-link...

Please let me know if this helps and leave a like if this information is useful, followups are appreciated.
Kudos
Ayushi

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group