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

[vineethpv]

Hi,

Anyone has implemented snowflake key pair authentication from ServiceNow. What should be the connection url to be updated in BR if we are using key pair authentication and also to which location should the files be uploaded?