BankOrg Data Platform / Environment Setup
Generate RSA Key Pair
Generate the encrypted private key and public key used for key-pair authentication to Snowflake.
The dbt service user authenticates to Snowflake with a key pair, with no password. The private key is encrypted and stays on the local machine; only the public key goes into Snowflake.
Generate the private key
Generate a 2048-bit RSA key and convert it to an encrypted PKCS#8 file.
mkdir -p ~/.snowflake && cd ~/.snowflake
openssl genrsa 2048 | openssl pkcs8 -topk8 -v2 des3 -inform PEM -out bankorg_dbt.p8
chmod 600 bankorg_dbt.p8Derive the public key
Derive the public key, bankorg_dbt.pub, from the private key.
openssl rsa -in bankorg_dbt.p8 -pubout -out bankorg_dbt.pub