Unable to access Databricks cluster through ODBC in R

uberweiss — Thu, 31 Aug 2023 07:57:11 GMT

We have previously been able to access our Databricks cluster in R using ODBC but it stopped working a couple of months ago and now i can't get it to connect.

I've downloaded the latest drivers and added the right information in odbc/odbcinst files but i still get an error when i try to connect.

Below is the code i'm running and the error i get:

conn <- odbcConnect("Databricks")Warning messages:
1: In RODBC::odbcDriverConnect("DSN=Databricks") :
  [RODBC] ERROR: state HY000, code 1170, message [unixODBC][Simba][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.
2: In RODBC::odbcDriverConnect("DSN=Databricks") : ODBC connection failed

And here's the details from my odbc.ini file:

[ODBC Data Sources] Databricks=Databricks ODBC Connector [Databricks] Driver=Simba Spark ODBC Driver 64-bit Server=our_server.com HOST=our_server.com PORT=443 SparkServerType=3 ThriftTransport=2 SSL=1 AuthMech=3 UID=token PWD=my_token

And below is from the odbcinst file:

[Simba Spark ODBC Driver 64-bit] Description=Simba Spark ODBC Driver (64-bit) Driver=/opt/simba/spark/lib/64/libsparkodbc_sb64.so

We have no issues on the same server to access the cluster from Python using the databricks-sql-connector so there should not be any issues with connectivity.

Any suggestions?

Re: Unable to access Databricks cluster through ODBC in R

uberweiss — Fri, 01 Sep 2023 07:37:50 GMT

Hi!

Thanks for your help, generated a new token and for some reason that seemed to have done the trick 🙂

topic Unable to access Databricks cluster through ODBC in R in Warehousing & Analytics

Unable to access Databricks cluster through ODBC in R

Re: Unable to access Databricks cluster through ODBC in R