How to provide private key file (p8 file) for snowflake database connection

Matillion ETL
1

Hi everyone,

i try to connect with database query component to a snowflake database. In my case i have to provide a privatekey file (p8 file) for the connection. I checked the Snowflake connection properties and so far i understand i have to store the p8 file locally at my Matillion instance and in connection property "privateKey" i have to set the location of the file like "path/rsa_key.p8".

 

My question now:

In which folder i have to store the p8 file at our Matillion instance and which path setting in have to use in property "privateKey"?

 

With best regards,

Dirk

2

@DirkZ​ - you don't have to upload your key-pair to the Matillion instance.

You will have to select "Password type" as "Private key" and store the private key in the Password Manager.

The public key is updated in Snowflake for the user you are trying to login as.

Find more details below:

https://www.matillion.com/resources/blog/connecting-matillion-etl-to-snowflake-a-guide

Snowflake setup:

https://docs.snowflake.com/en/user-guide/key-pair-auth

3

@DirkZ​ - I have stored the private key on the VM before for a specific situation. If you want to do similar, I discuss how in this article:

SSH Key & Password Storage Recommendations for Secure Scripting in Matillion

Hope this helps