Datagrip connection error

spijl
New Contributor III

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.

Alberto_Umana
Databricks Employee
Databricks Employee

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

spijl
New Contributor III

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.

View solution in original post