Multi Factor Authentication MFA
π What is Multi-Factor Authentication (MFA)?β
MFA is an authentication method that requires users to verify their identity using two or more factors:
- β Something you know (like a password)
- β Something you have (like a phone with a verification code)
Snowflake supports MFA to add an extra layer of security for user logins.
π― Why is MFA Important?β
βοΈ Prevents unauthorized access, even if passwords are compromised. βοΈ Enhances security for sensitive data in Snowflake. βοΈ Meets compliance requirements (GDPR, HIPAA, PCI-DSS, etc.). βοΈ Mitigates phishing and credential theft risks.
βοΈ How to Set Up MFA in Snowflakeβ
1οΈβ£ Enable MFA for Your Userβ
- Each Snowflake user can enable MFA in the Web UI.
Steps:
- Log in to the Snowflake web interface.
- Click on your username (top-right corner).
- Go to βPreferencesβ.
- Under Multi-Factor Authentication (MFA), click Enable.
- Follow the steps to register an authenticator app (like Google Authenticator, Authy, or Okta Verify).
2οΈβ£ Use MFA When Logging Inβ
- β Once MFA is enabled, youβll be prompted for a code from your authenticator app after entering your password.
3οΈβ£ Admin Control: Enforce MFAβ
Snowflake does not allow enforcing MFA at the account level directly. MFA is enabled by each user individually in the Snowflake UI.
-
β Best practice:
- Educate users on enabling MFA.
- Use an identity provider (IdP) (like Okta or Azure AD) for SAML SSO and enforce MFA via the IdP.
π§© Using MFA with SSO (Single Sign-On)β
βοΈ Best practice: Integrate Snowflake with your IdP using SAML. βοΈ Enforce MFA policies at the IdP level (Okta, Azure AD, etc.). βοΈ Users log in via SSO and MFA is enforced by the IdP.
β οΈ Limitations and Considerationsβ
β MFA cannot be enforced directly by Snowflake β itβs user-enabled. β If using Okta, Azure AD, etc., MFA enforcement is done on the IdP side, not in Snowflake.
-
β For highest security:
- Use IdP + SSO + MFA enforcement at the IdP.
- Disable direct username/password logins to Snowflake.
π‘ Best Practices for MFA in Snowflakeβ
- β Train all users to enable MFA.
- β Integrate Snowflake with an IdP (SAML SSO) for central MFA management.
- β Use reputable authenticator apps (Google Authenticator, Authy).
- β
Monitor login activity for suspicious logins (via
LOGIN_HISTORYviews).
π Key Takeawaysβ
βοΈ MFA adds a strong security layer to protect Snowflake access. βοΈ In Snowflake, MFA is enabled per user in the UI. βοΈ For enterprise-wide MFA enforcement, integrate with an IdP (Okta, Azure AD). βοΈ MFA helps meet compliance and reduce risk of data breaches.