Announcing Copilot for SQL Analytics Endpoint in Microsoft Fabric (Preview)
We’re excited to introduce Copilot for SQL Analytics Endpoint, now in preview – a transformative, AI-powered assistant built to change how you query, explore, and analyze data within Microsoft Fabric’s SQL experience.
With Copilot integrated directly into the SQL Analytics Endpoint, users can now express intent in natural language and instantly receive ready-to-run T-SQL. Whether you’re working with Lakehouse tables, dedicated Warehouses, or mirrored operational databases, Copilot accelerates the path from question to insight – unlocking analytics potential across your entire data estate with unprecedented speed and ease.
Unlocking value through Natural Language and SQL
Obtaining data is no longer difficult; the challenge lies in quickly deriving actionable insights. As organizations unify storage and compute with Microsoft Fabric, the real challenge moves upstream: navigating unfamiliar schemas, querying across different formats, and delivering analytics outcomes fast.
Copilot for SQL Analytics Endpoint removes that friction entirely. Instead of spending valuable time understanding table structures or stitching together cross-source joins manually, users can describe their goals in everyday language and instantly receive high-quality, performant SQL. Copilot acts as an accelerator at every step – helping users explore new domains, draft sophisticated queries, and learn best practices organically.
Fabric’s unified architecture becomes fully accessible, empowering every user to move faster, explore broader, and deliver insights with less guesswork and more confidence.
Designed for Fabric – Cross-Source SQL in OneLake
Copilot is deeply optimized for the architecture of Microsoft Fabric. The SQL Analytics Endpoint sits atop OneLake, offering a common SQL surface over diverse data types, including:
- Lakehouses & Shortcuts (Delta tables stored in an open format)
- Mirrored operational databases (such as Azure SQL, Cosmos DB, and others)
- Data Warehouses
Copilot understands how these different systems interact and generates T-SQL that works seamlessly across them. It respects Fabric’s security boundaries, leverages unified metadata from OneLake, and aligns to best practices for scalable, performant querying.
With Copilot, you can focus on questions and exploration – not on plumbing, translation, or troubleshooting.
Copilot for SQL Analytics Endpoint in the context of your business
Picture this: you need to tie customer orders from your mirrored CRM to fulfillment data in the Warehouse – something that normally requires digging through schemas, writing complex joins, and double-checking table relationships. With Copilot, you skip the heavy lifting. A simple prompt – ‘Get customer orders from CRM and join with fulfillment data from the warehouse‘ – returns a ready-to-run query that pulls exactly what you need, no manual schema deep dives required.
Or maybe you’re looking to blend product metadata in a Lakehouse with sales numbers stored in a Warehouse. Instead of bouncing between storage formats and trying to reconcile differences yourself, you ask Copilot: ‘Show me top-selling products by category using product metadata from the Lakehouse and sales from the warehouse.‘ Copilot does the heavy lifting, stitching sources together behind the scenes so you can focus on the insight, not the integration.
And when you’re under pressure to deliver quick insights – like pulling revenue by region for a quarterly review – Copilot has you covered there, too. Even if you’ve never touched the Finance Lakehouse, you can ask: ‘Show me total revenue by region for the last quarter using the Finance Lakehouse.‘ Copilot identifies the right tables, applies the correct filters, and generates the SQL you need without the typical back-and-forth.
Copilot transforms how you work with data: no more searching, stitching, or second-guessing. Complex environments become accessible. Insights flow faster. Data silos disappear. With Copilot in SQL Analytics Endpoint, you don’t just save time, you unlock the full power of Fabric and move from question to impact without missing a beat.
Getting started & next steps
Copilot for SQL Analytics Endpoint is available today in preview inside the SQL editor experience in Microsoft Fabric. Simply open a SQL Analytics Endpoint from your Lakehouse or mirrored database, describe your goal or question in natural language, and let Copilot generate your T-SQL.
This is just the beginning. We’re continuing to expand Copilot’s SQL capabilities – including deeper semantic understanding, enhanced cross-source intelligence, and tighter integration with governance and optimization – to make Fabric even more powerful and accessible for every user.
Get started with Copilot for SQL Analytics Endpoint: Copilot for Data Warehouse (Preview)
Check out our Data Warehouse roadmap: What’s new and planned for Synapse Data Warehouse in Microsoft Fabric
Have a feature request? Post your thoughts to Ideas (microsoft.com).
Join us in this exciting journey to make data more accessible, understandable, and actionable for everyone in your organization.
