Unable to connect with Databricks Serverless SQL using Dbeaver
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2024 04:27 AM
I am trying to connect to databricks serverless SQL pool using DBeaver as mentioned in the documentation below:
https://learn.microsoft.com/en-us/azure/databricks/dev-tools/dbeaver
I am trying to use the Browser based authentication i.e (OAuth user-to-machine (U2M) authentication).
I have prepared the URL properly in the below format:
jdbc:databricks://<server-hostname>:443;httpPath=<http-path>;AuthMech=11;Auth_Flow=2;TokenCachePassPhrase=<passphrase>;EnableTokenCache=0
When I test the connection in DBeaver, the browser opens for authentication, but the screens keep loading and it times out.
I tried restarting my system, clearing the browser cache, use both chrome and Edge but this problem persists.
I am able to login to the data bricks workspace so it is accessible to me.
Not sure why the Auth URL just keep loading and does not allow to login.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-23-2024 07:05 AM
There are few things we can start looking into:
-
Update DBeaver and JDBC Driver: Ensure that you're using the latest version of DBeaver and the Databricks JDBC driver. Sometimes, updating to the latest version can resolve connection issues.
-
Check OAuth settings: Since you're using OAuth for authentication, make sure that the OAuth settings are correctly configured in Databricks and that the account you're using has the necessary permissions.
-
Try a different authentication method: If possible, try using a different authentication method to see if the issue is specific to OAuth.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-27-2024 01:31 AM
Hi I checked on these items:
1. I am using the latest jdbc driver.
2. The user has access to data. He is able to query it in data bricks workspace using SQL query on the same data bricks serverless SQL pool.
3. I tried using personal access token and it is working fine. It is not working with the browser based authentication.
I want to use browser based authentication so that end users do not have to login to databricks and generate personal access tokens.
I am not sure why the auth page just keep loading and never shows login screen.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-22-2024 09:01 AM
I'm having the same problem. Any update?
