DBEAVER Connection to Sql Warehouse in Databricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2024 12:45 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-08-2024 10:21 PM
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:
Please let me know if this helps and leave a like if this information is useful, followups are appreciated.
Kudos
Ayushi

