Key Pair Authentication Support for Snowflake Reverse ETL Source
- free
- growth
- enterprise
less than a minute
- Date: Jul 3, 2024
RudderStack now supports Snowflake’s key pair authentication mechanism while setting up your Snowflake Reverse ETL source. You can now configure a key pair in Snowflake and use the private key for user authentication.
Snowflake’s key pair authentication mechanism leverages a 2048-bit RSA key pair and offers better security over basic authentication (username + password).
To use this feature:
- Set up a key pair in Snowflake.
- Set the Authentication Type to Key Pair Authentication.
- Specify the Private Key generated above, including the delimiters (
BEGIN RSA PRIVATE KEYandEND RSA PRIVATE KEY). - If the private key is encrypted, specify the Private Key Passphrase used for encryption. Otherwise, leave it blank.

See the Snowflake source documentation for more information.