JDBC connection for Snowflake using Key Pair Authentication

[Sanjay Sharma]

Hi all,

We are trying to establish JDBC connection to Snowflake using Key Pair Authentication. I have uploaded the Snowflake drivers JAR to Mid Server and configured a data source to build connection string to pass private key and password as per https://docs.snowflake.com/en/user-guide/jdbc-configure.html#using-key-pair-authentication.

However, I am getting following error while loading data into ServiceNow

MID Server reported error: java.sql.SQLException: net.snowflake.client.jdbc.SnowflakeSQLException: Private key provided is invalid or not supported: D:/snowflake/privatekey/rsa_keyP.p8: Cannot retrieve the PKCS8EncodedKeySpec

How can this issue be resolved as our internal security policies to connect Snowflake allow to use only via private that is encrypted?

Thanks!

[kalyan13]

Hello @Sanjay Sharma ,

Hope you're doing well!!!

We have a requirement to establish a JDBC connection to Snowflake using Key Pair Authentication. If you’ve successfully set this up on your end, could you please share the steps you followed?

Thank you in advance!

[YazminM]

I am also looking for connection URL with private key

[ShaliniJain]

Hi @Sanjay Sharma ,

We also have a similar requirement. Could you please guide on the steps or documents to set this up.

Thanks & Best Regards,

Shalini Jain