Is it possible to establish a Snowflake connection in KNIME using key pair authentication consisting of a Private Key File Path (PEM file) and a Private Key File Password? Or is it only possible with a username and password?
Hello @oroszlta,
according to Snowflake documentation this should be possible as JDBC driver
is listed to support key-pair authentication:
https://docs.snowflake.com/en/user-guide/key-pair-auth#supported-snowflake-clients
And here are instructions on how to set it up:
https://docs.snowflake.com/en/developer-guide/jdbc/jdbc-configure#using-key-pair-authentication-and-key-rotation
Good luck!
Br,
Ivan
1 Like