Skip to main content

Enabling Multi-Factor Authentication (MFA)

Multi-Factor Authentication (MFA) enhances the security of user logins by requiring a second verification step, such as a one-time password generated by an authenticator app. Snowflake allows account administrators to enforce MFA at the user level.


Key Takeaways​

  • MFA adds an additional layer of protection beyond username and password.
  • You can enable or disable MFA for individual users.
  • Users with MFA enabled will be prompted to configure it on their next login.
  • You can audit users with MFA enabled using Snowflake’s account usage views.

SQL Statements for MFA Configuration​

Enable MFA for a User:

ALTER USER <username> SET MFA_REQUIRED = TRUE;

Disable MFA for a User:

ALTER USER <username> UNSET MFA_REQUIRED;

View MFA Status of a Specific User:

SHOW USERS LIKE '<username>';

Query All Users with MFA Enabled:

SELECT name, mfa_required  
FROM SNOWFLAKE.ACCOUNT_USAGE.USERS
WHERE mfa_required = 'TRUE';

Describe User Details Including MFA:

DESC USER <username>;

Create a New User with MFA Enabled:

CREATE USER <username>  
PASSWORD = '<YourStrongPasswordHere>'
DEFAULT_ROLE = <role_name>
DEFAULT_WAREHOUSE = <warehouse_name>
DEFAULT_NAMESPACE = <database.schema>
MUST_CHANGE_PASSWORD = TRUE
MFA_REQUIRED = TRUE;

Notes​

  • MFA support in Snowflake is based on TOTP and is compatible with most authenticator apps like Duo, Google Authenticator, and Microsoft Authenticator.
  • For enterprise identity federation and centralized MFA policies, configure SSO via Okta, Azure AD, or other supported IdPs.
  • Users must complete MFA setup during their next login once it is enabled.