Upravit

Sdílet prostřednictvím


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:

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.