Skip to content
BENIBIX Learn

Fabric Data Warehouse

Data🧰 PlatformsData Platforms

Also known as Fabric Warehouse, Microsoft Fabric Warehouse

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

Think of it like

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

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.

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.
The warehouse is the right box. T-SQL can both read and write it.

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.

Key takeaways

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

Compare