topic Re: How to configure Job Parameters for a secure integration of Stats & Logs in Snowflake in Talend Studio

How to configure Job Parameters for a secure integration of Stats & Logs in Snowflake

CamilleLcq — Wed, 19 Feb 2025 12:27:51 GMT

Hi everyone,

I’m currently working on configuring job parameters to integrate "Stats and Logs" data into a Snowflake database within . Given that Snowflake will prohibit non-secure username/password connections starting in end of 2025, I’m looking for a secure method to achieve this.

Is it possible to set up a key pair connection for a Snowflake database type within the job parameters? Alternatively, can this be done securely using the JDBC connector, also configured with a key pair?

Currently, I do not see the option for a "Snowflake" database type or the ability to configure key pair authentication for JDBC in the stats and logs integration settings, as shown in the screenshots below :

Any guidance or examples on how to implement this securely would be greatly appreciated.

Thank you in advance for your help !

Re: How to configure Job Parameters for a secure integration of Stats & Logs in Snowflake

Dave_Simo — Wed, 19 Feb 2025 15:02:59 GMT

Hello @CamilleLcq

For your needs you can make the settings below by creating a connection to snowflake on your TMC.

Best Regards

Re: How to configure Job Parameters for a secure integration of Stats & Logs in Snowflake

CamilleLcq — Thu, 20 Feb 2025 09:09:08 GMT

Hi @Dave_Simo,

Thank you for your response. I noticed that the screenshot provided seems to show a connection using username and password. Could you please confirm if the connection to Snowflake supports secure key pair authentication instead of username and password?

Thank you & Best regards

Re: How to configure Job Parameters for a secure integration of Stats & Logs in Snowflake

Dave_Simo — Thu, 20 Feb 2025 12:52:58 GMT

Hello,

At the time on our project we used the basic connection to Snowflake as below but it is entirely possible to connect to it using key pair.

Best Regards

Re: How to configure Job Parameters for a secure integration of Stats & Logs in Snowflake

CamilleLcq — Tue, 25 Feb 2025 08:13:38 GMT

Hi @Dave_Simo,

Unfortunately, this does not resolve my issue as I am specifically looking to configure the Stats & Logs, not just establish a key pair connection to the Snowflake database.

Best regards,