I can’t find any recent discussion of this, and none of the older posts seem to get me in the right direction. I am trying to use KNIME desktop to connect to and analyze data in Snowflake. The organization uses SSO via Okta for Snowflake. I’ve tried adding “authenticator” parameters to both the native Snowflake and DB connector nodes (authenicator=https://mycompany.okta.com). I get an error that the specific Snowflake authenticator is not accepted by my snowflake account my snowflake account configuration.
I’m piloting KNIME at the company so need to be able to get a solution in place without a heavy lift from IT. Ideally, I’d like to be able to login via a browser similar to the native Google authenticator nodes.
…So I actually solved this. For anyone else looking to do this, here are the things that worked for me:
Use the DB Connector instead of the native Snowflake node. This lets you add the authenticator dimension to the URL (&authenticator=https://mycompany.okta.com)
In the JDBC Parameters, add a new one called authenticator with a value of externalbrowser
Use your OKTA username and password in the DBConnector node.
This will open an external browser for OKTA SSO, then allow you to execute queries.