Microsoft Entra ID + Snowflake integration
Set up Microsoft Entra ID as the identity provider for Snowflake via SAML + SCIM — via Entra ID gallery integration with SCIM provisioning.
- Entra Application Administrator
- Snowflake ACCOUNTADMIN
1. Create a new SAML 2.0 application in Entra ID
In the Entra ID admin console, create a new SAML 2.0 application. Choose "Web Application" type. Note the placeholders for ACS URL + Entity ID — you'll get these from Snowflake in step 3.
2. Get the SAML metadata URL from Entra ID
Entra ID exposes the IdP metadata at a stable URL. Copy this URL — you'll paste it into Snowflake's SSO configuration. Alternatively, download the metadata XML if Snowflake doesn't support URL-based metadata.
3. Configure SSO in Snowflake
In Snowflake's admin → security → SSO settings, paste the Entra ID metadata URL (or upload the XML). Snowflake will display the ACS URL + Entity ID it expects — copy these.
4. Return to Entra ID + complete the SAML app config
Paste Snowflake's ACS URL into the Entra ID app's Single Sign-On URL field. Paste the Entity ID into the Audience URI field. Set the NameID format to EmailAddress (or persistent if Snowflake expects that).
5. Configure attribute mapping
Map the attributes the SP expects (see the Attribute Mapping section below). At minimum, email is required. Most apps also expect firstName + lastName.
6. Assign users + groups
In Entra ID, assign the SAML app to users or groups that should have access. Test with a pilot group before broad rollout.
7. Test end-to-end
Sign in to Snowflake via the IdP-initiated link (from Entra ID dashboard) AND via SP-initiated (direct Snowflake login URL). Both should work. Check the SAML Tracer browser extension or SAML decoder to inspect the assertion if anything fails.
What flows from where.
| Source (Microsoft Entra ID) | Target (Snowflake) | Note |
|---|---|---|
| user.mail | NameID | — |
| user.userPrincipalName | LOGIN_NAME | — |
| user.givenName | FIRST_NAME | — |
| user.surname | LAST_NAME | — |
- Clock skew: Entra ID and Snowflake clocks must be within ~5 minutes. NTP-sync both. SAML's NotBefore + NotOnOrAfter are strict.
- NameID format mismatches are the most common failure. Snowflake typically wants EmailAddress; Entra ID defaults vary. Mismatch → cryptic "invalid assertion" errors.
- Just-in-time (JIT) provisioning vs SCIM: many apps support both. SAML JIT creates the user on first SSO; SCIM creates them ahead of time. Pick one — both can cause attribute drift.
- Audience restriction: Snowflake's expected Audience URI must match exactly what the IdP sends. Trailing slashes + protocol (http vs https) matter.
- Signed Response vs signed Assertion: many SPs require the Assertion to be signed (not just the Response envelope). Check the SP's docs.
- Same SECURITY INTEGRATION SQL requirement.
- Group provisioning: Entra group → Snowflake role mapping is one-to-one. Plan group naming carefully.
- IdP-initiated SSO works (sign in from the IdP dashboard)
- SP-initiated SSO works (visit Snowflake directly + get redirected to IdP)
- User attributes flow through correctly (email, name, groups)
- Logout (single logout if supported) works as expected
- Step-up MFA fires when policy requires it
- Unauthorized users (not assigned to the app) get a clean denied message
- Capture a successful SAML response and inspect it (use the SAML decoder tool)
For the latest vendor-side configuration changes, refer to:
Entra + Snowflake tutorial →