An art-of-the-possible project: a fully automated XDR where Cortex AI writes the detections, maps new log sources, triages, investigates, writes the reports and requests the response, all inside one Snowflake account. Humans step in only where a wrong decision is expensive, and one switch stops it all.
A tested reference architecture for connecting an enterprise AI chat platform to Snowflake Cortex Agents through the managed MCP server, so every question runs as the employee who asked it, with their row access, their masking and their name in the audit trail.
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.
Microsoft Sentinel’s native Snowflake connector shows your SOC logins and queries, but nothing about what Cortex Agents did. Here’s a reference implementation that sends agent traces, token usage and access history into Sentinel, so analysts can follow an agent conversation down to the data it touched.