A step-by-step guide for integrating Microsoft Copilot Studio agents with Snowflake Cortex using the Model Context Protocol (MCP). Covers setting up a Snowflake MCP Server that exposes a Cortex Agent as an MCP tool endpoint, configuring Snowflake OAuth (native) for authentication, and wiring the MCP connector in Copilot Studio. Includes SQL snippets for creating the MCP Server specification and OAuth security integration, plus notes on hostname formatting and role scope limitations.
Table of contents
Setup PrerequisitesConfiguring Snowflake OAuthGet Shankar Narayanan SGS’s stories in your inboxConfigure the Copilot Studio agentSort: