topic Re: Unable to connect with Databricks Serverless SQL using Dbeaver in Data Engineering

Unable to connect with Databricks Serverless SQL using Dbeaver

NarenderKumar — Fri, 22 Mar 2024 11:27:29 GMT

I am trying to connect to databricks serverless SQL pool using DBeaver as mentioned in the documentation below:

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.

Walter_C — Sat, 23 Mar 2024 14:05:43 GMT

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.

NarenderKumar — Wed, 27 Mar 2024 08:31:56 GMT

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.

binsel — Wed, 22 May 2024 16:01:49 GMT

I'm having the same problem. Any update?