Snowflake Key Pair Authentication Support for Profiles

Snowflake key pair authentication while setting up your Profiles project.
Available Plans
  • enterprise

  •   less than a minute  

  • Date: Jul 4, 2024

RudderStack now supports Snowflake’s key pair authentication mechanism while setting up your Profiles connection. 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:

  1. Set up a key pair in Snowflake.
  2. Create a warehouse connection to allow Profiles Builder (PB) to access your data by running the pb init connection command.
  3. In the subsequent setup, enter y (yes) for Do you want to use key-pair authentication.
  4. Enter the file path containing the private key.
  5. If the private key is encrypted, specify the Private Key Passphrase used for encryption.
  6. Continue with the rest of the warehouse connection setup.

See the Profiles CLI Setup guide for more information.

Questions? Let's figure it out together.

Join the RudderStack Slack community to connect with other users, customers, and the RudderStack team — or reach out for direct support.

Slack community Join now Email support Reach out