Skip to main content

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:

  1. Log in to the Snowflake web interface.
  2. Click on your username (top-right corner).
  3. Go to β€œPreferences”.
  4. Under Multi-Factor Authentication (MFA), click Enable.
  5. 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_HISTORY views).

πŸ”‘ 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.