Skip to content
BENIBIX Learn

Fabric Lakehouse

Data🧰 PlatformsData Platforms

Also known as Microsoft Fabric Lakehouse, Lakehouse in Microsoft Fabric

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

Think of it like

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

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.

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.
The lakehouse is the left box. Spark fills its two folders, and the SQL endpoint only reads.

Common mistake

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

Key takeaways

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

Compare