topic Configure SSL for connectivity to Snowflake in Installing and Upgrading

Configure SSL for connectivity to Snowflake

jwilkinson1665370444 — Fri, 15 Nov 2024 22:28:45 GMT

Hi All,

I am trying to establish connectivity to snowflake using a RSA key(.p8 file). However, Talend requires a keystone configuration to establish the connection.

I need help on steps to generate a keystone from a private RSA key(.p8 file). All solutions I've seen on the net require a cert which I do not have access to.

Any help would be appreciated.

Kind Regards,

Re: Configure SSL for connectivity to Snowflake

Anonymous — Tue, 11 Oct 2022 08:04:58 GMT

Hello,

Here is a tSetKeyStore component in talend, which is used to set the authentication data type between PKCS 12 and JKS.

The below link is very helpful in understanding the SSL certificate setup(Steps to create RSA key, self-signed certificates, keystore, and truststore for a server):

https://unix.stackexchange.com/questions/347116/how-to-create-keystore-and-truststore-using-self-signed-certificate

Hope it helps for your use case.

Best regards

Sabrina

Re: Configure SSL for connectivity to Snowflake

jwilkinson1665370444 — Tue, 11 Oct 2022 09:55:58 GMT

Hi Sabrina,

I skipped step 1 since I already have a RSA key(.p8 file). Running step 2 is giving the following error

Re: Configure SSL for connectivity to Snowflake

Anonymous — Wed, 12 Oct 2022 05:20:34 GMT

Hello,

I don't see the full error message from your screenshot.

Are your steps to create RSA key, self-signed certificates, keystore, and truststore for a server or client?

Best regards

Sabrina

Re: Configure SSL for connectivity to Snowflake

jwilkinson1665370444 — Wed, 12 Oct 2022 23:33:46 GMT

For snowflake connectivity, I have the RSA key, I have to put that key in a keystore

Re: Configure SSL for connectivity to Snowflake

Anonymous — Fri, 14 Oct 2022 04:20:58 GMT

Hello,

Is it OK with you to convert RSA keystore to jks keystore and then add the Certifying authority certificate and Client certificate to the trust store?

Best regards

Sabrina

Re: Configure SSL for connectivity to Snowflake

jwilkinson1665370444 — Mon, 17 Oct 2022 23:32:47 GMT

Hi Sabrina,

I was able to find the commands to do the same. I just had to generate a pem file and do a key tool insert, but thanks for the help

Re: Configure SSL for connectivity to Snowflake

ASonaji1668195652 — Fri, 11 Nov 2022 22:29:35 GMT

Hi., Can you provide the step you did., Thanks