BankOrg Docs

In progress

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.

Terminal
mkdir -p ~/.snowflake && cd ~/.snowflake
openssl genrsa 2048 | openssl pkcs8 -topk8 -v2 des3 -inform PEM -out bankorg_dbt.p8
chmod 600 bankorg_dbt.p8

Derive the public key

Derive the public key, bankorg_dbt.pub, from the private key.

Terminal
openssl rsa -in bankorg_dbt.p8 -pubout -out bankorg_dbt.pub