↓ Skip to main content
  1. Tags/

Saml

From SAML Login to Snowflake as the User: Entra ID Passthrough Without the Secondary-Role Trap

Your web app signs users in with SAML, and now it needs to query Snowflake as each user. A SAML assertion can’t be exchanged for an OAuth token, and the usual role-any shortcut leaves every other role active, ACCOUNTADMIN included. A tested pattern with Entra ID: a silent OIDC hop, role-scoped tokens, and a second External OAuth integration that puts Snowflake in charge of which roles the app may use.