Skip to Content

Lakehouse-Architektur

Version 2.1 by Dimitri Rupp on 2026/06/11 09:16
Warning
For security reasons, the document is displayed in restricted mode as it is not the current version. There may be differences and errors due to this.
Contents

💧 Fabric Lakehouse

Information

A Lakehouse in Microsoft Fabric is a unified data architecture that merges the scalability of a data lake with the structure and performance of a data warehouse, offering a single platform for storing, managing, and analyzing structured and unstructured data.

🗄️ Storage

Data is stored in Delta tables, which support ACID transactions, schema evolution, and time travel. A Lakehouse contains two zones — Tables and Files.

  • Tables — managed Delta tables with full metadata support
  • Files — unmanaged storage for raw data (CSV, Parquet, images, etc.), accessible via Spark but not queryable via SQL endpoint unless converted to Delta

🔄 Transformation

Dataflows Gen2, Notebooks (PySpark / Spark SQL), and Pipelines enable ingestion, cleansing, and transformation. These tools integrate natively with Lakehouses for modular, reproducible workflows.

🔐 Access

Lakehouses expose a SQL endpoint for T-SQL queries. Access is governed via Microsoft Entra ID, with support for workspace roles, item-level permissions, and Service Principals for secure external automation.

🏗️ Layers in our architecture

The SPL Fabric architecture follows the medallion pattern with three layers:

flowchart LR
    SRC[📂 Source Systems] --> B[🥉 Bronze
Landing zone]
    B --> S[🥈 Silver
Transformation]
    S --> G[🥇 Gold
Business-ready]
    G --> CONS[📊 Consumers
Power BI / Excel / Board]

    style B fill:#cd7f32,color:#fff
    style S fill:#c0c0c0,color:#000
    style G fill:#ffd700,color:#000

For detailed access instructions, see Get data from Lakehouse.

📋 Source-specific Bronze Lakehouses

The Bronze layer is split into individual Lakehouses per source system:

Information

Migration note: This page was migrated on 24.05.2026 from SharePoint WikiPowerBI into the Lumi-XWiki staging.

Original author: Bukkerji Sreejith (created 2025-10-07, last modified 2025-10-09)
Original source: Lakehouse (SharePoint)
Migration: Dimitri Rupp via ClaudeAI

Migration remarks:

  • Original language (English) preserved
  • SharePoint 3-card Editorial layout (Storage / Transformation / Access) converted to three H2 sections with bullet structure
  • Stock-image cards (Hubble) omitted — purely decorative
  • Mermaid Bronze→Silver→Gold flow added for the medallion architecture
  • Cross-links to all Lakehouse sub-pages prepared — those not yet migrated will appear red until later waves

Verwandte Themen

Failed to execute the [velocity] macro. Cause: [The execution of the [velocity] script macro is not allowed in [xwiki:IT-Wiki.Makros.Verwandte-Themen.WebHome]. Check the rights of its last author or the parameters if it's rendered from another script.]. Click on this message for details.

Status: Migriert — Team-Review ausstehend · Owner: (festlegen) · Letzter Review: 2026-06-11