Pinecone Nexus Microsoft OneLake Integration demo

A short walkthrough demonstrating the Pinecone Nexus integration with Microsoft OneLake. In this demo, Pinecone Staff Data Engineer Simon Lu showcases how easy it is to use Nexus to build a reliable, production-grade knowledge layer directly over structured data stored in Microsoft OneLake or a Fabric Data Warehouse. By creating an intuitive semantic layer, Nexus allows AI agents to accurately interpret complex enterprise schemas and answer business questions using natural language. What You'll Learn: The Setup (0:00): A look at the sample enterprise datasets in the Fabric console (Census, NYC Taxi, Holidays, and NYC 311 data). Connecting to Fabric (1:05): How to configure the connection using an Azure Service Principal and your SQL connection string. Adding Context Documents (1:55): How to upload markdown documentation, data dictionaries, or semantic models to bootstrap your knowledge base. Background Initialization (2:50): How the background agent explores tables, maps entity relationships, and automatically writes analytical data reports. Nexus in Action (3:42): A demo of the agentic chat playground handling complex, multi-table SQL queries from natural language prompts. Programmatic Access & Curation (4:54): How to integrate Nexus into your own agent workflows as a tool, and how to dynamically update the knowledge layer with feedback. Under the Hood (5:51): An inside look at the source page and the atomic knowledge artifacts Nexus generates to ensure consistent, highly accurate RAG performance. Learn more about the Pinecone Nexus integration with Microsoft Fabric: https://www.pinecone.io/newsroom/microsoft-onelake-nexus/