Configuring Snowflake Database For Key Pair Authentication
1. Create a username and password in Snowflake.
2. Assign the public key derived from the private key to your Snowflake user to enable key pair authentication.
Alter the user to use key pair authentication using the following command in Snowflake and replace rsa_public_key with the content from your public key file.
ALTER USER <your_username> SET RSA_PUBLIC_KEY='<your_public_key>'
For example:
ALTER USER JOHN SET
RSA_PUBLIC_KEY='MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtD7m97G2h9sNdkWeDBey
FhgUPLu2wbccYXT3vXwDudL2qFm7W6PxVaEj/k1bFeKcOHDI2jVVeHzU1awg1wxBJ3Jd2GJ9dYNmjGho
vLSrthbKbGMavlwU +QIDAQAB'
Note:
You must have the ACCOUNTADMIN role to make edits to a user.
3. Use the altered user in Snowflake Worksheets to verify key pair authentication.