topic Re: Datagrip connection error in Get Started Discussions

Datagrip connection error

spijl — Wed, 18 Dec 2024 19:12:06 GMT

I am trying to connect with Datagrip provided driver. I am not getting this to work with token from datagrips. The connection url is:

jdbc:databricks://dbc-******.cloud.databricks.com:443/***_analytics;httpPath=/sql/1.0/warehouses/ba***3

I am getting this error:

DBMS: Apache Spark (no ver.) Case sensitivity: plain=mixed, delimited=exact [08S01][500593] [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.

what to fix???

I also tried this method but still no sucess.

Re: Datagrip connection error

Alberto_Umana — Wed, 18 Dec 2024 19:46:09 GMT

Hello @spijl

Have you ensured that the token used for authentication is valid and has the necessary permissions to access the Databricks SQL warehouse. Tokens can be generated in the Databricks workspace under User Settings > Access Tokens

Re: Datagrip connection error

spijl — Wed, 18 Dec 2024 19:52:24 GMT

hi @Alberto_Umana thanks. I created the token in databricks under User Settings > Access Tokens indeed. Not sure how to ensure is valid and has the necessary permissions to access the Databricks SQL warehouse. I generated it recently though.