Add support for Snowflake key-pair authentication

ecerulm

Currently the dataiku only support "User/Password" and "OAuth" for Snowflake connection.

Snowflake has Key-pair authentication https://docs.snowflake.com/en/user-guide/key-pair-auth, which I would like to use for my service accounts.

Jorge

We are looking also to have this sort of functionality. It would be great to have this implemented allowing for extra security of the data

ecerulm

I was told by support that you can do the key pair authentication already today by using
custom JDBC properties

You can configure key-pair authentication via custom JDBC properties on the Snowflake connection by adding "private_key_file" and "private_key_file_pwd" properties: