Author: Venkata Shiva Krishna Jallu
Snowflake supports multi-factor authentication (i.e., MFA) to give users connecting to Snowflake a higher level of login security. MFA support is provided as an integrated Snowflake feature. It is powered by the Duo Security service, which is managed completely by Snowflake.
Snowflake highly advised that all users with the ACCOUNT ADMIN role be compelled to utilize MFA.
Steps to enable MFA in your Snowflake account
Login into your Snowflake account.
Use the role ‘ACCOUNT ADMIN’.
Go to Preferences at the rightmost corner of your Snowflake account; in Preferences, navigate to the General section.
In the general section, we can see Multi-factor-authentication; if you are not enrolled, click on the option ‘ Enroll in MFA’
After that DUO wizard will pops up; click on ‘start setup’ to start the configuration.
Select your device type.
Select your country and Enter your phone number.
Install duo mobile applications from the play store or app store, depending on your device.
Scan the QR code in your duo mobile application.
After successfully scanning the QR, click on continue.MFA is now enabled on your account.
Upon successfully submitting your Snowflake account credentials, a DUO MFA wizard will pop up.
Here we can get permission from the account admin to access Snowflake account in 3 ways:
We can send a Push notification. A notification will pop up in the account admin DUO mobile application, account admin accepts the push notification to give access.
Click Call Me to have login instructions sent to the registered mobile device by phone call.
To log in, click Enter a Passcode and manually enter a passcode generated by the Duo Mobile app.
Below is the example of DUO MFA enabled in our snowflake account: