Snowflake Connection Error with Okta SSO

[kevweath]

Both KNIME and Snowflake are somewhat new to my company. I am the first person at my company to look to connect to Snowflake via KNIME. I would really appreciate help to figure out setting up this connection - or at least helping me frame the questions so my IT staff can help me with this.

I have pieced together notes from the KNIME and Snowflake websites. I can do this successfully on my ‘home’ computer to a personal Snowflake account. However using my work laptop and connecting to my company’s Snowflake account is causing me trouble - almost certainly related to my company’s security.

My attempt at the jdbc url looks like this:

jdbc:snowflake://mycompany.us-east-1.snowflakecomputing.com/?authenticator=https://mycompany.okta.com

When I try this, I am getting this error:

ERROR DB Connector 0:1 Execute failed: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: sun.security.validator.ValidatorException: No trusted certificate found.

Other points in case they are helpful:

• Even with the &authenticator parameter in the url, KNIME is demanding a username and password.
• I get this same error even if I remove the &authenticator=https://mycompany.okta.com part of the url.

[ipazin]

Hello @kevweath,

and welcome to KNIME Community!

Guess you found this topic? User managed to connect to Snowflake with Okta adding &authentication=xxxx to the Snowflake connection string.

Additionally your error message seems like traffic network issue. There are many topics about it (and one FAQ question) and I suggest you search around forum a bit. Here is one that seems most similar to yours after a quick search:

KNIME Analytics Platform 4.2 Update - Cannot connect to extensions repository

Up until KNIME 4.2, I have had no problem reaching the extensions repository upon update. Now, I cannot access it. Based on the error message, there is a missing or failed certificate somewhere. Please help. I cannot use KNIME until this is fixed. KNIME Community Extensions (Trusted) https://update.knime.com/community-contributions/trusted/4.2 Here is the error message: Some sites could not be found. See the error log for more detail. Unable to read repository at https://update.knime.com/c…

And last but not least there is plan to have a dedicated Snowflake connector in future. Stay tuned!

Br,
Ivan

[ScottF]

Hi @kevweath -

It sounds like some certificates need to be added to your keystore? Tobias talks about that in a MySQL context in this thread:

Connection to MySQL with SSL (.pem + .key)

Hello, I’m trying to connect to an KNIME with a MySQL Database with SSL certificate (.pem) and a private key. Unfortunately I can’t find a way to include both files (.pem + .key) in a node or in the properties. Can anyone help me or has experience with such a connection? Thank you.

I also did a little digging and found this link on the Snowflake forum, which may be of some use to your IT folks:

Snowflake Community

I will also tag @tobias.koetter here to see if he has any specific suggestions for you about connecting to Snowflake in this case.