Make Safer Connections with Key Pair Authentication in Snowflake (and also in
Weary of using username and password for linking #snowflake with other tool? Learn how to set up Key Pair Authentication in this step by step tutorial!
The second part of the video explains how to connect the key pair to #dbt - the process is similar for other tools (e.g. #Fivetran).
Timestamps
00:00 intro
00:21 Generate Private Key for Key Pair Authentication
00:35 Add Password (Passphrase) for Key Pair Authentication
01:18 Generate Public Key for Key Pair Authentication
01:33 Safely Store Private and Public Keys
01:43 Link Public Key to Snowflake User
02:52 Connect dbt and Snowflake using Key Pair Authentication
Documentation: https://docs.snowflake.com/en/user-gu...