Microsoft Fabric Data Warehouse
activeby Microsoft · since 2023 · also known as Fabric Warehouse, Synapse Data Warehouse in Fabric
T-SQL warehouse in Microsoft Fabric that stores every table as Delta Parquet in OneLake.
Overview
Fabric Data Warehouse is the SQL engine inside Microsoft Fabric, the SaaS analytics suite that bundles data engineering, real-time analytics and Power BI on a single capacity. It is the successor to Synapse dedicated pools: a distributed engine (from the Polaris project) that runs full T-SQL with multi-table transactions, while storing every table as open Delta Lake Parquet in OneLake so Spark notebooks and Power BI Direct Lake read the same files without copying. It suits Microsoft shops consolidating BI and warehousing; capacity-based billing and a fast-moving feature set are the trade-offs.
Strengths & trade-offs
Strengths
- +Tables are open Delta Parquet in OneLake, readable by Spark and Power BI Direct Lake
- +Full T-SQL with multi-table ACID transactions, familiar to SQL Server teams
- +No clusters or distributions to configure; compute is allocated automatically
- +Single capacity covers warehousing, Spark, pipelines and Power BI
- +Zero-copy table clones and time travel queries
Trade-offs
- −Capacity-unit billing is hard to attribute and can throttle under bursts
- −T-SQL surface is still narrower than SQL Server (e.g. no triggers, limited types)
- −Azure-only, tied to the wider Fabric/Power BI licensing model
- −Younger product with frequent changes and preview features
Great for
- +Microsoft-centric enterprise data warehouse
- +Power BI backends with Direct Lake
- +Migrating Synapse dedicated SQL pools
- +Medallion lakehouse with a SQL serving layer
Think twice for
- −Non-Microsoft or multi-cloud stacks
- −Low-latency user-facing analytics
- −OLTP workloads
Capabilities
Native or official first-party support · 11 of 25 tracked
Scale & consistency
- Comfortable data size
- Large · ≤ 1 PB
- Horizontal scaling
- Native
- Multi-region
- No
- Transactions
- Full ACID
- Consistency
- Strong
- Schema
- Strict
- Architecture
- Serverless, Distributed, Shared storage
- Query languages
- T-SQL
Compute is allocated automatically within the purchased Fabric capacity; storage in OneLake scales independently.
Deployment
available on · Azure
Ecosystem
Alternatives to Microsoft Fabric Data Warehouse
Azure analytics service combining MPP dedicated SQL pools, serverless SQL and Spark.
microsoft-fabric-warehouse vs azure-synapse-analytics →Fully managed cloud data warehouse with separate storage and compute, now spanning AI and apps.
microsoft-fabric-warehouse vs snowflake →Serverless SQL warehouses on the Databricks lakehouse, powered by the Photon C++ engine.
microsoft-fabric-warehouse vs databricks-sql →Google's serverless, pay-per-query data warehouse built on Dremel and Colossus.
microsoft-fabric-warehouse vs google-bigquery →AWS's MPP columnar data warehouse, available as provisioned RA3 clusters or Serverless.
microsoft-fabric-warehouse vs amazon-redshift →Fast distributed SQL query engine for federated analytics across lakes and databases.
microsoft-fabric-warehouse vs trino →Microsoft Fabric Data Warehouse FAQ
What is Microsoft Fabric Data Warehouse?
Microsoft Fabric Data Warehouse is a columnar / OLAP database by Microsoft, first released in 2023. Fabric Data Warehouse is the SQL engine inside Microsoft Fabric, the SaaS analytics suite that bundles data engineering, real-time analytics and Power BI on a single capacity. It is the successor to Synapse dedicated pools: a distributed engine (from the Polaris project) that runs full T-SQL with multi-table transactions, while storing every table as open Delta Lake Parquet in OneLake so Spark notebooks and Power BI Direct Lake read the same files without copying. It suits Microsoft shops consolidating BI and warehousing; capacity-based billing and a fast-moving feature set are the trade-offs.
Is Microsoft Fabric Data Warehouse open source?
No. Microsoft Fabric Data Warehouse is proprietary, closed-source software.
Does Microsoft Fabric Data Warehouse support ACID transactions?
Yes. Microsoft Fabric Data Warehouse supports full ACID transactions, with strong consistency.
Does Microsoft Fabric Data Warehouse scale horizontally?
Microsoft Fabric Data Warehouse scales horizontally out of the box, with built-in sharding or partitioning. It is comfortable at large scale (≤ 1 PB).
How can I run Microsoft Fabric Data Warehouse?
You can use the vendor's managed cloud and run it serverless. It is available on Azure.
What is Microsoft Fabric Data Warehouse best for?
Microsoft Fabric Data Warehouse is a strong fit for microsoft-centric enterprise data warehouse, power BI backends with Direct Lake and migrating Synapse dedicated SQL pools. Think twice for non-Microsoft or multi-cloud stacks.
What are the best alternatives to Microsoft Fabric Data Warehouse?
Common alternatives to Microsoft Fabric Data Warehouse include Azure Synapse Analytics, Snowflake, Databricks SQL, Google BigQuery and Amazon Redshift. The right choice depends on your workload, scale and hosting; WhichDB's smart match ranks them against your requirements.
How popular is Microsoft Fabric Data Warehouse?
Microsoft Fabric Data Warehouse ranks #356 of 844 databases on the WhichDB Score (6.7/100), and #34 among columnar / OLAP databases. The score combines public adoption signals such as package downloads, GitHub activity, job posts and developer discussion.