In this in-depth session, I team up with Snowflake expert Maciek Jarka to show how Microsoft Copilot Studio can be connected with Snowflake Cortex Search to enable conversational AI over unstructured data—empowering business users who don’t know SQL.

We start by configuring OAuth (covered in Part 1), then walk through the architecture, grounding techniques, and OCR integration for image-based content. You’ll see how to design, build, and deploy a Copilot agent that can securely query raw Snowflake data, publish it to Microsoft Teams, and maintain compliance with enterprise security and data residency requirements.

The session also covers cost considerations, best practices for data chunking, and security strategies to ensure safe, traceable AI interactions with enterprise data.