Events
31 Mar, 23 - 2 Apr, 23
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: ✅ SQL database in Microsoft Fabric
SQL database in Microsoft Fabric is a developer-friendly transactional database, based on Azure SQL Database, that allows you to easily create your operational database in Fabric. A SQL database in Fabric uses the same SQL Database Engine as Azure SQL Database.
To learn more about SQL database in Fabric, watch a Data Exposed episode introducing on the SQL database in Microsoft Fabric public preview.
Important
This feature is in preview.
To get started with a full walkthrough, see the tutorial to Create a SQL database in the Fabric portal. If you want help with a particular task, visit the Get started section.
SQL database in Fabric is:
Intelligent performance features from Azure SQL Database are enabled by default in SQL database in Fabric, including:
Important
This feature is in preview.
SQL database in Fabric is part of the Database workload, and the data is accessible from other items in Fabric. Your SQL database data is also kept up-to-date in a queryable format in OneLake, so you can use all the different services in Fabric, such as running analytics with Spark, executing notebooks, data engineering, visualizing through Power BI Reports, and more.
With your SQL database in Fabric, you don't need to piece together different services from multiple vendors. Instead, you can enjoy a highly integrated, end-to-end, and easy-to-use product that is designed to simplify your analytics needs, and built for openness and collaboration between technology solutions that can read the open-source Delta Lake table format. The Delta tables can then be used everywhere in Fabric, allowing users to accelerate their journey into Fabric.
The Microsoft Fabric platform is built on a foundation of Software as a Service (SaaS). To learn more about Microsoft Fabric, see What is Microsoft Fabric?
SQL database in Fabric creates three items in your Fabric workspace:
Data in your SQL database is automatically replicated of into the OneLake and converted to Parquet, in an analytics-ready format. This enables downstream scenarios like data engineering, data science, and more.
A SQL analytics endpoint
A default semantic model
In addition to the Fabric SQL database Query Editor, there's a broad ecosystem of tooling including SQL Server Management Studio, the mssql extension with Visual Studio Code, and even GitHub Copilot.
Sharing enables ease of access control and management, while security controls like row level security (RLS) and object level security (OLS), and more make sure you can control access to sensitive information. Sharing also enables secure and democratized decision-making across your organization.
By sharing your SQL database, you can grant other users or a group of users access to a database without giving access to the workspace and the rest of its items. When someone shares a database, they also grant access to the SQL analytics endpoint and associated default semantic model.
Access the Sharing dialog with the Share button next to the database name in the Workspace view. Shared databases can be found through OneLake Data Hub or the Shared with Me section in Microsoft Fabric.
For more information, see Share data and manage access to your SQL database in Microsoft Fabric.
Like other Microsoft Fabric item types, SQL databases rely on Microsoft Entra authentication. For options to connect, review Connect to your SQL database in Microsoft Fabric.
To successfully authenticate to a SQL database, a Microsoft Entra user, a service principal, or their group, must have the Read item permission for the database in Fabric. For more information, see Authentication in SQL database in Microsoft Fabric.
With the data from your SQL database automatically stored in the OneLake, you can write cross-database queries, joining data from other SQL databases, mirrored databases, warehouses, and the SQL analytics endpoint in a single T-SQL query. All this is currently possible with queries on the SQL analytics endpoint of the SQL database, or lakehouse.
For example, you can reference a table from other items in Fabric using three-part naming. In the following example, use the three-part name to refer to ContosoSalesTable
in the warehouse ContosoWarehouse
from the fictional SalesLT.Affiliation
table in a SQL database. From other databases or warehouses, the first part of the standard SQL three-part naming convention is the name of the database or warehouse item.
SELECT *
FROM ContosoWarehouse.dbo.ContosoSalesTable AS Contoso
INNER JOIN AdventureWorksLT.SalesLT.Affiliation AS Affiliation
ON Affiliation.AffiliationId = Contoso.RecordTypeID;
Microsoft Fabric provides various data engineering capabilities to ensure that your data is easily accessible, well-organized, and high-quality. From Fabric Data Engineering, you can:
Data Science in Microsoft Fabric to empower users to complete end-to-end data science workflows for the purpose of data enrichment and business insights. You can complete a wide range of activities across the entire data science process, all the way from data exploration, preparation and cleansing to experimentation, modeling, model scoring and serving of predictive insights to BI reports.
Microsoft Fabric users can access Data Science. From there, they can discover and access various relevant resources. For example, they can create machine learning Experiments, Models and Notebooks. They can also import existing Notebooks on the Data Science Home page.
SqlPackage is a cross-platform command line tool that enables database interactions that move entire databases or database objects. The portability (import/export) of a database managed in Azure or in Fabric ensures that your data is portable should you want to migrate later on. The same portability also enables certain migration scenarios through self-contained database copies (.bacpac) with import/export operations.
SqlPackage can enable easy database deployments of incremental changes to database objects (new columns in tables, alterations to existing stored procedures, etc.). SqlPackage can extract a .dacpac file containing the definitions of objects in a database, and publish a .dacpac file to apply that object state to a new or existing database. The publish operation also integrates with SQL projects, which enables offline and more dynamic development cycles for SQL databases.
For more information, see SqlPackage with SQL database in Fabric.
SQL database is integrated with Fabric continuous integration/continuous development. You can use the built-in git repository to manage your SQL database.
You can use the Fabric portal to easily create a GraphQL API for your SQL database.
You can use the Microsoft Fabric Capacity Metrics app to monitor the SQL database usage and consumption in non-trial Fabric capacities.
Note
During the current preview, no billing will occur for SQL database in Fabric, but billing metrics will still flow for tracking purposes.
Do you already have an external database and want to leverage Fabric's integration? You can use Mirroring in Fabric as a low-cost and low-latency solution to bring data from various systems together. You can continuously replicate your existing data estate directly into Fabric's OneLake, including data from an existing Azure SQL Database.
Fabric SQL database doesn't support the Azure SQL Database elastic pools concept by name, but similar concepts are available with Fabric capacities and Fabric workspaces. A single Fabric capacity can provide resources for Fabric SQL databases in different workspaces. This provides both a simplification of billing in a single capacity similar to elastic pools, as well as security isolation for different workspaces.
Events
31 Mar, 23 - 2 Apr, 23
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Get started with SQL Database in Microsoft Fabric - Training
Learn how SQL Database in Microsoft Fabric works, the key concepts, and practical examples to help users SQL Database effectively as part of their analytics solutions.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.
Documentation
Databases in Microsoft Fabric - Microsoft Fabric
Learn about the Databases workload in Fabric
Fabric decision guide - choose an operational database - Microsoft Fabric
Review a reference table and scenarios to choose the most suitable operational database for your transactional workloads.
Frequently asked questions for SQL database in Microsoft Fabric (preview) - Microsoft Fabric
This article answers frequently asked questions about SQL database in Microsoft Fabric (preview).