Skip to Content

Fabric Gold Lakehouse

Version 1.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.
On this page

Fabric Gold Lakehouse

Information

Lakehouse: spl_gold_lh
Stage: Gold — Final / Trusted Zone
Owner: Tightly controlled (database roles)

Overview

The Gold layer represents the final, trusted zone in the data pipeline architecture. It hosts business-ready, aggregated, and validated datasets optimised for reporting, analytics, and downstream consumption via Power BI, semantic models, and external applications.

Gold Lakehouse summary

📋 DataTables and Views stored in schemas. Data is cleaned, transformed, and ready for reporting, analytics, and consumption.
🔄 TransformationData is processed and moved using Python and Spark notebooks.
🔐 AccessDatabase roles enforce access. No access for external applications. User groups can read specific tables and views via the SQL endpoint.

Organisation, access and governance

All data is stored in a single Lakehouse — spl_gold_lh — which is organised using schema separation, with schema names aligned to source domains for clarity and governance.

To support organisation-wide sharing and simplify access management, shortcuts are no longer recommended in this Lakehouse. Avoiding shortcuts eliminates the need for additional permissions on the underlying Lakehouses, reducing complexity and potential access issues.

Access to spl_gold_lh is tightly controlled:

  • Only designated user groups — such as PBI Power Users — are granted SQL-endpoint access.
  • Schema-level and object-level permissions are enforced using database roles, ensuring fine-grained control over data exposure and operational integrity.

Architecture

flowchart LR
    SIL[(spl_silver_lh
Silver — transformed)] -->|Python / Spark notebooks| GOLD[(spl_gold_lh
Gold — trusted)]

    GOLD --> SQLE[SQL endpoint]
    SQLE -->|database roles| RG1[PBI Power Users]
    SQLE -->|database roles| RG2[Other designated groups]

    GOLD --> PBI[Power BI
reports and semantic models]
    GOLD --> EXT[External applications
read-only via SQL endpoint]

    classDef sil fill:#c0c0c0,stroke:#555,stroke-width:1px,color:#000
    classDef gold fill:#ffd54f,stroke:#b45f06,stroke-width:1px,color:#000
    classDef sec fill:#ffe0b2,stroke:#b45f06,stroke-width:1px,color:#000
    classDef cons fill:#e3f2fd,stroke:#1976d2,stroke-width:1px

    class SIL sil
    class GOLD,SQLE gold
    class RG1,RG2 sec
    class PBI,EXT cons

Comparison Bronze / Silver / Gold

BronzeSilverGold
PurposeRaw landing zoneTransformation zoneTrusted, business-ready
Lakehouses5x (BMD, Rimo, Board, SharePoint, H3A)1x spl_silver_lh1x spl_gold_lh
Shortcuts allowedn/a — sourcesYes — referencing BronzeNo — sharing/governance reason
TransformationsNoneCleansing, joining, enrichmentAggregations, business-ready datasets
ConsumersFabric teamFabric team / pipelinesPower BI, semantic models, external apps (read-only)
Access controlRestricted to Fabric teamWorkspace membersDatabase roles (group-based)

Schemas and objects in spl_gold_lh

Information

Note: The table catalog is a fully functional embedded Power BI report. Please wait for a few seconds for the report to load. If a permission error is observed, please contact the Power BI admins.

Warning

Live-Embed: Im XWiki-Staging ist der Power-BI-Embed nicht direkt einbettbar (Authentifizierung gegen den SPL-Tenant erforderlich). Die Quelle ist als externer Link unten verlinkt; beim Transfer ins Ziel-Wiki (SPL-Tele intern) ist der Unknown macro: powerbi. Click on this message for details.

Views in spl_gold_lh

Shows the view definition and dependencies.

Information

Note: Der Katalog ist ebenfalls ein eingebetteter Power-BI-Report. Bitte einen Moment auf den Ladevorgang warten. Bei einem Permission-Error: Power-BI-Admins kontaktieren.

Report: Views in spl_gold_lh (Power BI)

Operational notes

  • No shortcuts: Gold vermeidet bewusst Shortcuts. Tabellen werden persistent geschrieben, um Sharing und Governance zu vereinfachen.
  • SQL endpoint als zentraler Zugang: Externe Anwendungen und Power Users lesen ueber den SQL endpoint, nicht ueber die Lakehouse-API.
  • Database roles: Berechtigungen werden auf Schema- und Objekt-Ebene per Rolle vergeben — nicht pro User.
  • Semantic models: Power BI semantic models konsumieren aus Gold und stellen die letzte Modellierungs-Schicht fuer Reports dar.

Related pages

Information

Migration footer
Source: Fabric Gold Lakehouse (SharePoint)
Original author: Bukkerji Sreejith — Sreejith.Bukkerji@spl-tele.com
Original last-modified: 2025-10-15
Migration date: 2026-05-24
Migrated by: Dimitri Rupp via ClaudeAI
Notes: EN-Original-Texte 1:1; 3-card-Layout zu Summary-Tabelle; Mermaid Architektur-Diagramm (Silver → Gold → SQL endpoint → Konsumenten) ergaenzt; Bronze/Silver/Gold-Vergleichstabelle hinzugefuegt fuer Orientierung; zwei Power-BI-Embeds (Tables + Views) als externe Links bewahrt + Hinweis fuer Embed-Mechanismus im Ziel-Wiki dokumentiert; dekorative Hubble-Stock-Bilder ausgelassen.

Verwandte Themen

Kuratiert — kann direkt im Editor ergänzt werden://

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