Snowflake Key Pair Authentication Support for Profiles

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

  •   less than a minute  

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.

info
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? Contact us by email or on Slack