Unlocking LLM-Powered through Data Agent from your Mirrored Databases in Microsoft Fabric
Fabric Data Agent now support mirrored databases–making it easier than ever to put your operational data to work with AI.
As organizations depend on an ever-growing mix of data sources, the ability to seamlessly integrate and analyze data—no matter where it resides—is critical. This is where mirroring in Fabric comes in. With open mirroring, you can bring data from Independent Software Vendors (ISVs) directly into Fabric’s Delta Parquet format, ensuring it stays automatically in sync with the source. Now, with mirrored database artifacts connected directly to data agents in Fabric, you can unlock the power of Large Language Models (LLMs) to query, reason over, and generate insights from your operational data–accelerating time-to-insight across your entire data estate.
What Are Mirrored Database Artifacts?
Mirrored database artifacts are representations of your external databases—such as Azure Cosmos DB, Azure SQL Database, Oracle, Snowflake, Databricks—mirrored into Microsoft Fabric. This enables you to leverage Fabric’s AI-driven analytics and LLM capabilities over data that previously lived outside the Fabric ecosystem.
Supported Mirrored Artifacts in Data Agent include:
- Mirrored Azure Cosmos DB
- Mirrored Azure Database for PostgreSQL
- Mirrored Azure Databricks catalog
- Mirrored Azure SQL Database
- Mirrored Azure SQL Managed Instance
- Mirrored Oracle
- Mirrored Snowflake
- Mirrored SQL Server Database
With the latest release, users can add mirrored artifacts directly to Fabric Data Agent. Users no longer need to create an intermediary Lakehouse to bridge this gap. Once connected, the data agent leverages its NL2SQL (Natural Language to SQL) capability to generate and execute SQL queries against the SQL Analytics Endpoint built into the mirrored artifact. This means users can ask natural language questions and get instant, actionable insights—powered by LLMs—across all your mirrored data sources.
Key Features and Benefits
By connecting mirrored artifacts directly–without extra steps–you can unlock instant insights, streamline workflows, and power smarter applications across your data estate.
- Direct Integration: Add mirrored artifacts as data sources in Fabric data agents without the need for intermediate Lakehouses or shortcuts.
- AI-Driven Analytics: Use data agent’s built-in NL2SQL to query your data in plain English and receive insights instantly.
- Broad Compatibility: Integrate data from Azure, Oracle, Snowflake, Databricks, and more.
- Customizable Knowledge: Curate the data agent with instructions, data source instructions, and few-shot queries for all mirrored data sources.
- Scoped Context: Select relevant tables to focus the data agent’s knowledge and responses.
- Seamless AI Application: Bridge the gap between your external data and AI applications in Microsoft Fabric.
Getting Started
- Mirror Your Database: Use mirroring for Azure databases, or open mirroring to bring external databases into Microsoft Fabric as a mirrored artifact.
- Add to Data Agent: In the data agent interface, add the mirrored artifact as a data source.
- Curate and Query: Customize your data agent with instructions and examples, then start asking questions in natural language to generate LLM-powered insights.
What’s Next?
Microsoft Fabric is continuing to expand support for additional data sources. Coming soon, you’ll be able to connect SQL Database artifacts.
To learn more about data agent, check out the Fabric data agent concepts (preview) documentation.
For more details on how to mirror your databases into Fabric, review the Open Mirroring documentation.
Summary
By connecting mirrored database artifacts directly to Fabric Data Agent, you can unlock the full power of LLM-driven analytics across all your data—no matter where it lives. This new capability makes it easier than ever to bridge the gap between your data and AI, empowering you to make smarter, faster decisions.
