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!

[SupriyaWaghmode]

Unfortunately, no we did not get any trick to resolve this.

Thanks,

Supriya

[SupriyaWaghmode]

@Sanjay Sharma --

Can you please suggest how I can configure key-pair authentication for snowflake ??

[kalyan13]

hello @SupriyaWaghmode , Have you implemented this ?

[SupriyaWaghmode]

@kalyan13 

There are documents availed for steps at Snowflake key-pair authentication.  

https://docs.snowflake.com/developer-guide/jdbc/jdbc-configure#using-key-pair-authentication-and-key...

Please mark helpful if this resolves you query 

[kalyan13]

@SupriyaWaghmode , Yes we have created the private key and passphrase but when we are trying to build a connection it getting failed. What steps you have took from servicenow side to use JDBC private key, Could you please provide the steps if possible it will be help full, because as OOTB servicenow will not allow JDBC key pair