SQL database in Microsoft Fabric (Preview)
Applies to: Azure SQL Database SQL database in Microsoft Fabric
With SQL database in Microsoft Fabric, based on Azure SQL Database, you can easily create your operational database in Fabric.
What is the SQL database in Fabric?
To learn more about SQL Database in Microsoft Fabric, see:
- Features comparison: Azure SQL Database and SQL database in Fabric (Preview)
- FAQ for SQL database in Microsoft Fabric (Preview)
- 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.
Mirroring with SQL database in 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.