CODEWITHSUNDEEP
ssassnowflake-cloud-data-platform
Eric Mamet
Eric Mamet

Reputation: 3671

failing to process SSAS Tabular using Snowflake backend through ODBC

I am trying to process a SSAS Tabular model that connects through ODBC to a Snowflake database and get the following errors

OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] [Snowflake][Snowflake] (4) 
      REST request for URL https://ohXXXXX.us-east-1.snowflakecomputing.com:443/session/v1/login-request?requestId=46bd15ee-b045-4ab5-8e56-0c987e28ea24&request_guid=fad00bf2-43bd-4bb8-9280-e4b269cda05d failed: CURLerror (curl_easy_perform() failed) - code=60 msg='SSL peer certificate or SSH remote key was not OK' osCode=9 osMsg='Bad file descriptor'.
    
ERROR [HY000] [Snowflake][Snowflake] (4) 
      REST request for URL https://ohXXXXX.us-east-1.snowflakecomputing.com:443/session/v1/login-request?requestId=46bd15ee-b045-4ab5-8e56-0c987e28ea24&request_guid=fad00bf2-43bd-4bb8-9280-e4b269cda05d failed: CURLerror (curl_easy_perform() failed) - code=60 msg='SSL peer certificate or SSH remote key was not OK' osCode=9 osMsg='Bad file descriptor'.

It takes a little while for the connection to fail.

Using the same ODBC connection, I am able to load the data into my cube within Analysis Services in Visual Studio.

Any idea what I might be doing wrong?

Thanks

Eric

Upvotes: 0

Views: 371

Answers (1)

Suzy Lockwood
Suzy Lockwood

Reputation: 1180

Looks like a device might be intercepting the certificate. Does your company have any proxies, firewalls, security policies? Anything like Netskope or ZScaler?

There's a function you can run mentioned in the docs that will retrieve the list of hosts that need to be whitelisted in order for Snowflake operations to run smoothly from clients. You can send that list to your network engineering team to whitelist/bypass as needed.
https://docs.snowflake.com/en/user-guide/hostname-whitelist.html

Upvotes: 0

Related Questions