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

[CamilleLcq]

Hi everyone,

I’m currently working on configuring job parameters to integrate "Stats and Logs" data into a Snowflake database within Talend Studio. 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 !

[Dave_Simo]

Hello @CamilleLcq 

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

Best Regards

[CamilleLcq]

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

[Dave_Simo]

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

[CamilleLcq]

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,