# Fabric Data Warehouse

> The SQL warehouse in Microsoft Fabric. You load and change it with T-SQL.

**Field:** Data Engineering  
**Category:** Platforms  
**Also known as:** Fabric Warehouse, Microsoft Fabric Warehouse

## Think of it like

It is like a filing box. Each sheet goes in its own slot and stays there.

## Definition

Fabric Data Warehouse is the SQL warehouse inside Microsoft Fabric. You build and load it with T-SQL, the kind of SQL that SQL Server uses. Unlike a lakehouse's SQL endpoint, it can add, change and delete rows. A change that spans many tables either all happens or none of it does. Its tables are kept as Delta tables in OneLake. So Spark and Power BI can read them too.

## Example

A finance team keeps its star schema in a Fabric warehouse. A nightly T-SQL script loads the new sales, and Power BI reads them with no copy.

## Why it matters

Teams who know SQL Server can work in Fabric without learning Spark. Microsoft points new warehouse users here.

## Common mistake

Giving a SQL-only team a lakehouse. If they write T-SQL and need to change rows, the warehouse is the better fit.

## Three principles

- **T-SQL.** The SQL Server kind of SQL.
- **Read and write.** Add, change and delete rows.
- **All or nothing.** Changes across tables land together.

## Related terms

- [Microsoft Fabric](https://learn.benibix.com/term/data/microsoft-fabric)
- [Fabric Lakehouse](https://learn.benibix.com/term/data/fabric-lakehouse)
- [OneLake](https://learn.benibix.com/term/data/onelake)
- [Data Warehouse](https://learn.benibix.com/term/data/data-warehouse)
- [Azure Synapse Analytics](https://learn.benibix.com/term/data/azure-synapse-analytics)
- [Microsoft SQL Server](https://learn.benibix.com/term/development/sql-server)
- [Database Transaction](https://learn.benibix.com/term/development/transaction)

## Told apart from

- [Fabric Lakehouse vs Fabric Data Warehouse](https://learn.benibix.com/compare/fabric-lakehouse-vs-fabric-data-warehouse): People think a Fabric lakehouse and a Fabric warehouse are the same SQL store, and they are not. Both keep Delta tables in OneLake. A lakehouse is filled by Spark and holds loose files too. Its SQL endpoint can only read. A warehouse is built with T-SQL, which can add, change and delete rows. Pick the lakehouse for Spark teams and the warehouse for SQL teams.

![A wide band at the bottom is an F64 capacity with 64 capacity units, shared by everything above. On it sit a lakehouse, with a Tables folder, a Files folder and a read-only SQL endpoint, and a warehouse that T-SQL can read and write. Both store their tables in one OneLake strip between them and the capacity.](https://learn.benibix.com/diagrams/dat3-fabric-items.svg)

---

Source: https://learn.benibix.com/term/data/fabric-data-warehouse
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
