Summary
This document explains the steps needed to prepare your Snowflake environment for a dScribe connection. The connection we use is the Key Pair Authentication that Snowflake provides.
Step-by-step guide
Generate an encrypted private key in your terminal via the following command
openssl genrsa 2048 | openssl pkcs8 -topk8 -inform PEM -out rsa_key.p8t
Select a private keyphrase to encrypt the key, and keep this keyphrase somewhere safe (you'll need it later)
Generate the public key based on your private key
openssl rsa -in rsa_key.p8t -pubout -out rsa_key.pub
Assign the public key to the snowflake user via the following command
ALTER USER dscribe SET RSA_PUBLIC_KEY='MIIBIjANBgkqh...';
You can verify if your private key will work to connect to your Snowflake system via the SnowSQL client
snowsql -a <account_identifier> -u <user> --private-key-path <path>/rsa_key.p8
Your account identifier can be found in the Snowflake cockpit via Organization
The account identifier of the example above is 'AWTKGVC-QZ80313'
If your connection is verified you can move to the next step
Collect the following information to add in dScribe
Your account URL
Your account identifier as described above
Your private key
Your key passphrase
Username of the snowflake user
Using the Account identifier, Private key, Passhphrase and Username, you can now create a new Source in dScribe.
Reached the end? Congratulations! You’re a star! ⭐