I want to connection to a client Snow flake Connection in Ignition. So I install require JDBC driver and translator.
As Snowflake has enhanced their security posture, due to which the days of username and password are gone. Now for a "service" type account the best option is RSA Key Pair authorization and our client only provide this instead of password.
So I wonder how should use RSA Key p8 file in the Ignition Snowflake connection?
There is apparently some JDBC connection parameters that are used to point to a KeyStore file: Keypair JDBC Authentication for Snowflake
Seems at least one person has had success, but no follow up with details.
1 Like
EDIT: didn't realize your link was to the same post hah. The Keypair documentation on the snowflake site is fairly straightforward as well
My post asking about the same thing with a mini update
We were able to get it to work. Unfortunately, I do not have visibility into the Snowflake admin side of things if that is where the root of the problem is
1 Like