End-to-End AI Solution: Copilot Studio + Snowflake Cortex Search for Unstructured Data

In this session, we explore how to integrate Microsoft Copilot Studio with Snowflake Cortex Search to enable conversational access to unstructured data—without building traditional data pipelines. #copilotstudio #snowflake #cortexsearch #ocr #unstructureddata #conversationalAI #enterpriseAI 📹 Complete the prerequisite video first: Before diving into this session, please watch and complete the Part 1: https://www.youtube.com/watch?v=9RsVvJY07M8&t=58s ✅ What you’ll learn in this video: 1. Overview & Business Problem – Why unstructured data needs conversational access 2. Introduction to Snowflake Cortex Search & Cortex Complete 3. High-Level Design – Architecture using Copilot Studio, Cortex Search & grounding 4. Quick Demo – Conversational agent in action 5. Hands-On Development 6. Cost considerations for Cortex Search and OCR 7. Security best practices for enterprise data 8. Wrap-up: Enabling self-service insights from raw Snowflake data 💡 By the end of this session, you'll understand how to securely connect Microsoft Copilot Studio to Snowflake Cortex Search, leverage OCR for image-based content, and empower business users to chat with unstructured data—while ensuring traceability and data residency in Snowflake. 📚 Resources & Scripts 1. Getting Started with Microsoft Copilot Studio and Snowflake Cortex Agents: https://quickstarts.snowflake.com/guide/getting_started_with_microsoft_copilot_studio_and_cortex_agents/index.html#0 2. Snowflake Cortex Search Quickstart: https://docs.snowflake.com/en/user-guide/snowflake-cortex/cortex-search/overview-tutorials 3. Code blocks that are used in this demo: a. https://github.com/maciekjarka/snowflake_samples/blob/main/cortex_search.sql b. https://github.com/maciekjarka/snowflake_samples/blob/main/finance_get_output.sql 🤝 Connect with us on LinkedIn: 1. Snowflake Expert: Maciek Jarka: https://www.linkedin.com/in/maciek-jarka-13b96036/ 2. Copilot Studio Expert: Rafsan Huseynov: https://www.linkedin.com/in/rafsanhuseynov/ 00:00 – Intro 00:56 – Agenda 01:53 – Business Scenario 03:51 – High-level Architectural Design 04:50 - Solution Walk-through in Copilot Studio 16:56 – What is Cortex Search and How It Works 25:00 - Configuration of File Chunking using Cortex Search 46:10 – Configuration of Connecting Copilot Studio with Cortex Search 59:00 - Publishing Copilot Agent to Microsoft Teams 1:02:35– Pricing Overview 1:09:07 – Security Considerations 1:12:06 – Wrap-Up 👉 Subscribe for more demos on Copilot Studio, Snowflake, and real‑world AI‑powered workflows!