Exciting Announcement: Introducing Snowflake's Latest Feature - RSA Key Authentication

News Product News
, ,
1

Exciting Announcement! :rocket:

We’ve introduced RSA Certificate Authentication for the Integration Service Snowflake connector.
RSA certificate authentication offers enhanced security by using public-key cryptography. It eliminates the need for passwords, reducing the risk of unauthorized access and providing a robust and scalable authentication solution.

Learn how to generate your RSA Key Pair at: Key-pair authentication and key-pair rotation | Snowflake Documentation.

Once you’ve established the credentials, set up a new Snowflake connection.
Click the gear icon, choose the RSA certificate type, input credentials, and you’re ready to proceed!

image
image512×753 30 KB

image
image344×744 22.8 KB

Happy automating! :star2:

9 Likes
3

Hi,
I’ve just tried connecting to Snowflake using the RSA key and I got the following error message: 4077529920529368596 : Unauthorized: Invalid credentials. Make sure to specify private key password. If you are using encrypted RSA private key, then make sure that the user authenticating has already been configured with the RSA public key associated with the RSA private key provided.
While I have a valid connection using Username and Password, when changing the authentication type to RSA Certificate doesn’t work for me unfortunately.
I can confirm that the public key is successfully assigned to the user by running the DESCRIBE USER command in Snowflake.
Could you please help? Would you need more information from my side?
Thank you!

Best regards,
Marius

4

Hi @Marius_Istudor , Appreciate you posting this feedback regarding Snowflake RSA. We’ll definitely take a look at your request and get back.

5

@Samrat_Dutta, Hi, thank you for your reply. I have also opened a ticket with Snowflake support. Could you please confirm what it is the exact value I would need to fill in for the RSA private key? Is it the passphrase, is it the actual private key from the PEM file? Thanks!
Best regards,
Marius

6

We are also having this same issue. Has you found a resolution to this?

I can confirm functionality via OpeSSL and Snowflake. But I get the same error in UiPath. I have tried using the Private Key password (as indicated), Private Key and Public Key but none work and all produce the same error.

7

Hi @Marius_Istudor and @Jeremy_Loman - We have validated the functionality and able to reproduce the issue when an encrypted key is being used. However for an unencrypted key everything should work fine and you can still use the RSA private key.

If the need is to use an encrypted private key, it will be an enhancement on our end.
Please let us know if using an encrypted key is what you intend to do.
Also yes, you need to fill in the actual private key from PEM file.

8

Hi Samrat,

Thank you! I will try this approach tomorrow!

“This email and any attachments may be confidential or legally privileged and are intended solely for the use of the individual or entity addressed. If you have received this email in error please notify the sender and delete it from your email system. Additionally, you are notified that disclosing, copying, distributing or taking any action or reliance on the contents of this information is strictly prohibited.”

9

Sure @Jeremy_Loman, let us know when you’ve taken a look.
@Marius_Istudor - Did you get a chance to take a look at my reply? Pls let us know if you need anything else.

Thanks,
Samrat

10

@Jeremy_Loman any update on this??