Hello Team,

We are looking to establish jdbc connection with Snowflake with key pair authentication, unfortunately it is not working as expected, we have followed the instruction given in the documentation but still no luck, any one can help here?

Doc ref - Generating a Pair of Key Based Authentication - IBM Documentation


Error - Error encountered

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource Eric_SnowflakeConnector:sf_temp.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class "net.snowflake.client.jdbc.SnowflakeBasicDataSource".
Cannot create connection because password is missing in DataSource properties.

Below are my current setup :
KeyStore Alias :


user=demo_user;account=zercowp-mib82023.snowflakecomputing.com;warehouse=my_warehouse;db=my_database;schema=PUBLIC;role=demo_role;keyPairAuthN=true;private_key_file=C:/SoftwareAG/IntegrationServer/conf/privatekey.pem;

Note my key doesn't have any passkey and it is not encrypted.

The first thing I notice is that you're specifying the key twice. According to the doc, this property should not be set: private_key_file=C:/SoftwareAG/IntegrationServer/conf/privatekey.pem

Configuring Adapter Connection to Use Key Pair Authentication for Snowflake Database - IBM Documentation

I'm not saying that's the answer but removing that param is the first thing I would try.

HTH.

Hello @Theo Ezell,

I did try with configuration that you mentioned still getting the same error. but when I added authenticator property as SNOWFLAKE_JWT I am getting invalid private key error.
Configuration :

Error : 

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource SnowflakeConnector:fresh_sf.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.204] Cannot connect to the database with DataSource class "net.snowflake.client.jdbc.SnowflakeBasicDataSource".
Private key provided is invalid or not supported: Use java.security.interfaces.RSAPrivateCrtKey.class for the private key

Note ; I am able to connect to snowflake using the same private key and same jar file from a java program.

Thanks and Regards,
Mukesh

What I meant was to only remove the file name because you are specifying the key in the key store. So:

user=demo_user;account=zercowp-mib82023.snowflakecomputing.com;warehouse=my_warehouse;db=my_database;schema=PUBLIC;role=demo_role;keyPairAuthN=true;

If that doesn't work, I recommend opening a support incident.

HTH,

Theo

[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource SnowflakeConnector:fresh_sf.[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.[ADA.1.204] Cannot connect to the database with DataSource class "net.snowflake.client.jdbc.SnowflakeBasicDataSource".Private key provided is invalid or not supported: Use java.security.interfaces.RSAPrivateCrtKey.class for the private key