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.