topic Re: connection to databricks data source in Visual Studio fails with SSL error in Data Engineering

connection to databricks data source in Visual Studio fails with SSL error

geertvanhove — Wed, 16 Mar 2022 12:47:02 GMT

Hi,

I'm new to databricks but am positively surprised by the product. We use databricks delta tables as source to build a tabular model, which will serve as data source for Power Bi.

To develop our tabular model we use Visual studio to import tables and views from Databricks.

Since we had to generate a new token, this connection fails giving following error.

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed.

Details:

DataSourceKind=Spark

DataSourcePath=https://westeurope.azuredatabricks.net:443/sql/protocolv1/o/...

OdbcErrors=[Table]

We use apache-spark-http as protocol. AuthenticationKind = UsernamePassword; UserName=token. Password=new token generated by databricks service.

Refreshing the model on azure analysis services works fine, there it uses the new token correctly to the databricks service. But any connection (import tables, schema refresh, ...) to the databricks data source in Visual Studio generates the SSL-error.

Re: connection to databricks data source in Visual Studio fails with SSL error

Hubert-Dudek — Wed, 16 Mar 2022 14:22:04 GMT

In Visual Studio do you use databricks-connect? Maybe it is enough to rerun "databricks-connect configure"

Re: connection to databricks data source in Visual Studio fails with SSL error

geertvanhove — Wed, 16 Mar 2022 14:43:06 GMT

Hi,

thanks for your reply.

Does this also count for Visual Studio ( not only Visual Studio Code)?

I'm using Visual Studio to manage a Tabular Model project.

Re: connection to databricks data source in Visual Studio fails with SSL error

-werners- — Wed, 16 Mar 2022 14:56:39 GMT

@geert vanhove , Is the combo Databricks/SSAS supported nowadays? Because I think about 6 months ago that was not the case.

MS advised using power bi or Synapse (Serverless).

Re: connection to databricks data source in Visual Studio fails with SSL error

geertvanhove — Wed, 27 Apr 2022 06:55:12 GMT

this is fixed, it was linked to firewall settings

thanks

Re: connection to databricks data source in Visual Studio fails with SSL error

Ion_Donica — Thu, 26 May 2022 10:15:04 GMT

@geert vanhove , How did you achieve the successful connection between SSAS tabular and Databricks ? could you show a generic example?