DBEAVER Connection to Sql Warehouse in Databricks

ADBQueries — Mon, 08 Apr 2024 07:45:49 GMT

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

Re: DBEAVER Connection to Sql Warehouse in Databricks

Ayushi_Suthar — Tue, 09 Apr 2024 05:21:05 GMT

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-failure-failed-to

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

topic Re: DBEAVER Connection to Sql Warehouse in Databricks in Data Engineering

DBEAVER Connection to Sql Warehouse in Databricks

Re: DBEAVER Connection to Sql Warehouse in Databricks