Compared to the basic authentication using a username and password, the key pair authentication method offers an additional layer of security.
For the key pair authentication, you need to provide a username, private key and optional passphrase.
- Username is the username to the Snowflake instance you want to connect to. The corresponding public key must be assigned to this username. The corresponding user must have sufficient permissions for the database. Note that using the account admin role isn't recommended. Learn more about Snowflake prerequisites and permissions.
- The private key is generated according to the instructions in Snowflake documentation. Copy the entire key, including the start and end tags, and paste it into the field.
If the multiline value could not be copied, replace each new line character with a space character and copy the key as one huge line. - Optional passphrase. If the private key is encrypted, it has a passphrase. If the key doesn’t have a passphrase, leave the field blank.
Learn to generate the key pair (private and public key) and assign the key to a user with instructions in Snowflake documentation.
Instructions
Create a new Snowflake destination with key pair authentication
- Go to the Storage destinations page on the Supermetrics Hub.
- Click New storage and select Snowflake Data Warehouse.
- Fill in the connection details.
- Under Authentication method, select the key pair authentication method.
- Insert the username, private key, and private key passphrase, if applicable.
- Click Test to test the connection to your destination. If the test is successful, click Save to store the destination.
Set up key pair authentication for an existing Snowflake destination
- Go to the Storage destinations page on the Supermetrics Hub.
- Edit an existing Snowflake destination.
- Under Authentication method, select the key pair authentication method.
- Insert the username, private key, and private key passphrase, if applicable.
- Click Test to test the connection to your destination. If the test is successful, click Save to store the destination.