SQL database in Microsoft Fabric
Product
A transactional SQL database that runs inside Microsoft Fabric on the same engine as Azure SQL Database. Its data is automatically mirrored into OneLake for analytics.
Description
SQL database in Microsoft Fabric is a developer-friendly transactional database that runs inside Microsoft Fabric. It is built on the same SQL Database Engine as Azure SQL Database and belongs to the Fabric Database workload. Its main role is that of an operational OLTP store: applications write and read transactional data in it, while the same data becomes available for analytics inside the Fabric platform.
The central mechanism is automatic replication. Data stored in the database is replicated into OneLake as Delta Lake parquet files, so it is available for analytical use almost in real time. An SQL analytics endpoint is created automatically in the workspace, which gives analytical workloads a way to query the replicated data without building a separate pipeline. This links transactional and analytical workloads in one environment, a combination that the documentation names as typical scenarios such as translytical applications, operational data stores and reverse ETL, alongside intelligent applications.
Developers can work with the database through several tools. The Fabric portal offers a web query editor, and SQL Server Management Studio, the MSSQL extension for Visual Studio Code and GitHub Copilot are also supported. Further features described in the documentation include automatic tuning with automatic index creation, vector data types for semantic search and retrieval-augmented generation, a GraphQL API, and Git integration. On the security side, the documentation lists row-level and object-level security, customer-managed keys at workspace level, SQL auditing, and sharing without granting workspace access. Authentication uses Microsoft Entra, and access requires read permission on the database item.
Billing for the database runs through Fabric capacity rather than through separate Azure SQL pricing constructs. This matters when deciding between this item and a standalone Azure SQL Database, because consumption is tied to the capacity that the workspace already uses. The documentation also lists limits that influence that decision: only the default connection policy is supported, elastic pools in the Azure SQL sense do not exist, and some monitoring features are still in preview.
In the context of M365.FM, the product appears in the episode "Microsoft Fabric Data Warehouse - Simply Explained". That episode points listeners to training material that includes a module titled "Get started with SQL Database in Microsoft Fabric", described as covering the basics of SQL databases within the platform. It sits in a list of learning resources next to modules on real-time data processing, data science, designing scalable semantic models and Microsoft Fabric IQ fundamentals. The episode frames these modules as a foundation for understanding and navigating Microsoft Fabric.
Taken together, SQL database in Microsoft Fabric fits situations where an application needs a familiar relational engine for transactions and where the resulting data should flow into OneLake without manual export steps. Because it shares its engine with Azure SQL Database, existing SQL skills and tools carry over, while the automatic mirroring into Delta parquet files connects it to the analytical side of Fabric.
Overview compiled with AI from M365.FM episodes and the facts on this page. You can improve it with the edit button below.
| Type | Product |
|---|---|
| Documentation | SQL database in Microsoft Fabric – Microsoft Learn learn.microsoft.com |
Frequently asked questions
Questions marked with AI were written with AI from the facts on this page.
What is SQL database in Microsoft Fabric? (AI)
It is a transactional SQL database inside Microsoft Fabric, built on the same SQL Database Engine as Azure SQL Database. It is part of the Fabric Database workload and serves as an operational OLTP store.
How does its data become available for analytics? (AI)
Data is automatically replicated into OneLake as Delta Lake parquet files, so it is available for analytics almost in real time. An SQL analytics endpoint is also created automatically in the workspace.
How is SQL database in Microsoft Fabric billed and accessed? (AI)
Billing runs through Fabric capacity. Access is authenticated with Microsoft Entra and requires read permission on the database item.
Community wiki
Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.
Experts and companies for this topic
Nobody has listed this topic yet. Add it to your profile.
Sources
- SQL database in Microsoft Fabric – Microsoft Learn learn.microsoft.com
Maintained by Mirko Peters (Microsoft MVP) · Last updated: