Network Policies & MFA

Snowflake · Advanced Security & Governance

Theory

RBAC controls what a user can do after logging in; network policies and authentication controls decide who can log in at all. A network policy lists allowed and blocked IP addresses (newer setups reference network rules) and can be set on the account or on individual users, with a user-level policy taking priority over the account one. Connections from addresses that are not allowed are rejected.

Multi-factor authentication adds a second factor such as a passkey, an authenticator app code or Duo, and Snowflake is making it mandatory for password sign-ins by people. Stronger options avoid passwords altogether: key-pair authentication for service users and scripts, and single sign-on through SAML or OAuth with an identity provider such as Okta or Microsoft Entra ID.

Why we use it

Stolen passwords are a common cause of data breaches. Limiting where connections can come from and requiring strong authentication means a leaked password alone is not enough to reach the data.

When to use it

Apply an account-level network policy for known office, VPN and tool IP ranges, use SSO with MFA for people and key pairs for service users. Test a new account-level policy on a single user first so you do not lock yourself out.

Network Policies (IP Allowlisting)

A network policy defines allowed (and optionally blocked) IP ranges; attached to the account or a specific user, it rejects login attempts from outside the allowed list before credentials are even checked.

Multi-Factor Authentication

Snowflake MFA supports passkeys (recommended), authenticator apps that generate one-time codes, and Duo. Snowflake is rolling out mandatory MFA for every password sign-in by human users, and authentication policies let admins control which methods are allowed. Service users cannot use MFA and should use key-pair or OAuth instead.

SSO, SAML & OAuth

For enterprise accounts, federated authentication through SAML or OAuth lets users log in with their existing corporate identity provider, centralizing access control outside Snowflake itself.

How it works

  1. Login attempt
  2. Is the client IP allowed by the user's or account's network policy? Yes: Continue to authentication. No: Reject the connection.
  3. Authenticate: SSO, key pair or password
  4. Is MFA required for this user? Yes: Verify the second factor. No: Create the session.
  5. Session starts with the user's default role

Example

CREATE OR REPLACE NETWORK POLICY office_only_policy
  ALLOWED_IP_LIST = ('203.0.113.0/24')
  BLOCKED_IP_LIST = ('203.0.113.99');

ALTER ACCOUNT SET NETWORK_POLICY = office_only_policy;
ALTER USER john_smith SET NETWORK_POLICY = office_only_policy;

SELECT NAME, HAS_MFA_TOKEN FROM SNOWFLAKE.ACCOUNT_USAGE.USERS WHERE DELETED_ON IS NULL;

Key points

Snowflake topics

Snowflake Fundamentals

Warehouses & Performance

Staging & SnowSQL

Tables & Data Handling

Cloud Integrations

Storage & Optimization

Security & Governance

Views, Pipelines & Automation

Data Types & SQL Fundamentals

Semi-Structured Data Deep Dive

Advanced Features

Data Sharing & Collaboration

Cost Management & Monitoring

Databases, Schemas & Objects

Performance Deep Dive

Advanced Security & Governance

Stored Procedures & UDFs

Ecosystem & Integrations

SnowPro Certification Prep

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Mastering Snowflake

The modern data cloud, from architecture to SnowPro certification. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice Snowflake SQL Sharpen the SQL you use in Snowflake: 150 query problems in a live editor with instant checking. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Snowflake  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

{{ sec.h }}

{{ sec.body }}

{{ sec.body }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax
{{ current.syntax }}
Example
{{ current.example }}
Want to run this yourself? Unlike the SQL and Python courses, Snowflake needs a real account — there's no in-browser engine for it. Click Copy above, then paste it into a free Snowflake trial (30 days, no card required) and run it in Snowsight.
Key Points — click to check off as you learn
  • {{ pt.mark }} {{ pt.text }}

Share this topic