topic Re: Changing Auth from Password to Keypair issues in Qlik Replicate

Changing Auth from Password to Keypair issues

SHARMA-G — Fri, 16 May 2025 11:42:01 GMT

I am currently working on transitioning the authentication method for an existing user setup in Snowflake from password-based authentication to key pair authentication within Qlik Replicate. I am following the official guide provided by Qlik, but I am encountering an issue.

In the Qlik Replicate Console, under Manage Endpoint Connections, I only see options for OAuth and Password authentication in the dropdown menu—there is no option for Key Pair Authentication or upload keys. Given that my version is 2023.11, I would like to understand if there is a workaround or if key pair authentication is supported in this version.

Re: Changing Auth from Password to Keypair issues

SHARMA-G — Fri, 16 May 2025 12:17:30 GMT

just to add I have followed the exact instruction and i am gettig this error I can see the private keys in the location ihave specified :

Cannot connect to Cloud server
RetCode: SQL_ERROR SqlState: HY000 NativeError: 45 Message: [Snowflake][Snowflake] (45) Error loading private key file: No such file or directory.

Re: Changing Auth from Password to Keypair issues

lilizou — Fri, 16 May 2025 12:20:02 GMT

Hi @SHARMA-G

Key pair authentication for Snowflake is not supported in the November 2023 version you’re using. It is available starting from the May 2024 release.

I recommend you upgrading to May 2024 if you want to use key pair.

Re: Changing Auth from Password to Keypair issues

SHARMA-G — Fri, 16 May 2025 12:30:19 GMT

Thanks for the clarification. So, this error is due to the need for a version upgrade rather than an issue with the steps I followed. Since the guide I referenced was written in 2022 which is prior to the ver I am using, so I thought this should work, is there a more updated version available? link I am looking is https://community.qlik.com/t5/Official-Support-Articles/How-to-setup-Key-Pair-Authentication-in-Snowflake-and-How-to/ta-p/1987060

Re: Changing Auth from Password to Keypair issues

john_wang — Sat, 17 May 2025 02:11:27 GMT

Hello @SHARMA-G ,

The link you mentioned is good enough.

You may download Replicate 2024.5 SR1 , or 2024.11 from https://community.qlik.com/t5/Download-Qlik-Products/tkb-p/Downloads.

Good luck,

John.