# Fabric Lakehouse

> A Fabric store for tables and files. Spark writes to it, and SQL reads it.

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

## Think of it like

It is like a room with two shelves. Neat boxes go on one, and loose things go on the other.

## Definition

A Fabric lakehouse is a store in Microsoft Fabric that holds both tables and loose files. Its Tables folder holds Delta tables, and its Files folder holds the rest. Engineers fill it with Spark notebooks and pipelines. Each one comes with a SQL endpoint, so analysts can query its tables with T-SQL. That endpoint can read the data but not change it. All of it is kept in OneLake.

## Example

A team lands raw JSON files in Files. A notebook turns them into a Delta table in Tables. Analysts then query that table from Power BI, with no copy.

## Why it matters

It is where most engineers start in Fabric. One copy of the data serves both Spark and SQL.

## Common mistake

Trying to update rows through the SQL endpoint. It is read only, so changes must come from Spark or a pipeline.

## Three principles

- **Tables and Files.** Delta tables, plus loose files.
- **Spark writes.** Notebooks and pipelines fill it.
- **SQL reads.** A read-only endpoint for analysts.

## Related terms

- [Microsoft Fabric](https://learn.benibix.com/term/data/microsoft-fabric)
- [OneLake](https://learn.benibix.com/term/data/onelake)
- [Fabric Data Warehouse](https://learn.benibix.com/term/data/fabric-data-warehouse)
- [Data Lakehouse](https://learn.benibix.com/term/data/data-lakehouse)
- [Delta Lake](https://learn.benibix.com/term/data/delta-lake)
- [Apache Spark](https://learn.benibix.com/term/data/apache-spark)

## 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-lakehouse
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.
