What is Fabric Warehouse

Definition

The Fabric warehouse is Microsoft Fabric's fully managed, SQL-based data warehouse that stores data in OneLake and supports familiar T-SQL querying and transactions, giving analysts and engineers a scalable, structured warehouse experience within the unified Fabric platform.

« Back to Glossary Index

Provides a familiar T-SQL warehouse experience over OneLake
Scales structured analytics without managing infrastructure
Shares data in OneLake with other Fabric workloads, no copies
Supports transactions and multi-table operations for reliable analytics

Real World Example

An analytics team builds a Fabric warehouse for its curated reporting tables, querying them with standard T-SQL while the same data in OneLake remains accessible to lakehouse notebooks and Power BI without duplication.

FAQs

What is the Fabric warehouse?

It is Fabric's managed, T-SQL data warehouse that stores data in OneLake and supports structured, transactional analytics.

How does it differ from a Fabric lakehouse?

The warehouse is SQL-first with full transactional T-SQL, while the lakehouse is file-and-table oriented for data engineering and Spark.

Does the warehouse duplicate data?

No, it stores data in OneLake, so the same data is shared with other Fabric workloads rather than copied.