| title | SQL database in Fabric | |
|---|---|---|
| description | Learn about SQL database in Microsoft Fabric, based on Azure SQL Database, a developer-friendly operational database. | |
| author | WilliamDAssafMSFT | |
| ms.author | wiassaf | |
| ms.reviewer | antho, sukkaur | |
| ms.date | 10/17/2024 | |
| ms.service | fabric | |
| ms.topic | concept-article | |
| ms.custom |
|
|
| monikerRange | =azuresqldb-current || =fabric-sqldb |
[!INCLUDE asdb-fabricsqldb]
With SQL database in Microsoft Fabric, based on Azure SQL Database, you can easily create your operational database in Fabric.
To learn more about SQL Database in Microsoft Fabric, see:
- Features comparison: Azure SQL Database and SQL database in Fabric
- FAQ for SQL database in Fabric
- Microsoft Fabric decision guide: choose a SQL database
To get started, create a SQL database in the Fabric portal then connect to your SQL database in Microsoft Fabric.
With SQL database in Fabric, your data is automatically accessible from other Fabric experiences. Your SQL database in Fabric is mirrored to OneLake and presented in a read-only, queryable format. You can use all the different services in Fabric, including analytics with Spark, executing notebooks, data engineering, Power BI Reports, and more.
SQL database in Fabric uses similar change feed technology as the Fabric mirrored database feature for Azure SQL Database, and shares some system objects. SQL database in Fabric contains a changefeed database user, a changefeed schema, and several tables within the changefeed schema in your source database. Do not alter any of these system-managed objects.