Make Safer Connections with Key Pair Authentication in Snowflake (and also in #dbt)

preview_player
Показать описание
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

Рекомендации по теме
Комментарии
Автор

Thank you for clarifying at the end the need for BEGIN & END PRIVATE KEY statements, had that issue with my snowflake connector until I came across your video and tried it out :)

sirlanceohlot
Автор

Hey Serra, I use to watch your tutorials. You visited my article recently. The VOICE- Real-Time Voice Cloning.

akashrawat
Автор

Hi Thanks for this making this video. Its useful. I am also looking how can we user key-pair authentication with JDBC in Java code. Can you share any link where there is live demo. your help will be apreciated.

arunprajapati