cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
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

2 REPLIES 2

Kaniz
Community Manager
Community Manager

Hi @ADBQueries

Ayushi_Suthar
Honored Contributor
Honored Contributor

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