SharePoint Bronze Lakehouse

Last modified by Dimitri Rupp on 2026/06/11 09:30

On this page

SharePoint Bronze Lakehouse

SharePoint Bronze Lakehouse

Source system: SharePoint — diverse SPL sites (lists, libraries, Excel files)
Stage: Bronze (raw landing zone)
Owner: Fabric team (restricted access)

Overview

📋 What	Data from various SharePoint sites in SPL — landed in Bronze without transformations.
🔄 How	Notebooks and Dataflows (Python / Gen2).
🔐 Who	Access is restricted to the Fabric team.

About this Lakehouse

sharepoint_bronze_lh is the landing zone for all the data from the SharePoint files in SPL. This Lakehouse is schema-enabled, and the tables are stored in schemas matching the source name — unlike rimo_bronze_lh, which had to fall back to a flat dbo schema because Fabric did not yet support custom schemas at the time of provisioning.

Note — Telefónica Excel files: The Telefónica Excel files are included in this Lakehouse as shortcuts from the northlakepmo2 ADLS account. Since these files are not stored in Delta format, they do not appear under the Tables section of the Lakehouse. To access them, navigate to the Files section and browse to the telefoncia_staging folder.

Orchestration

Property	Value
🛠️ Tool	Python Notebooks (primary), Gen2 Dataflows
ℹ️ Function	Copy data from SharePoint files to Lakehouse
⚡ Trigger	On refresh schedule
🕞 Time	Week days

flowchart LR
    subgraph SP[SharePoint sources]
        direction TB
        S1[SPL SharePoint
Sites & Lists]
        S2[Excel files]
        S3[Telefonica Excel
shortcut to ADLS]
    end

    subgraph ORC[Orchestration]
        direction TB
        NB[Python Notebooks]
        DF[Gen2 Dataflow]
    end

    S1 --> NB
    S2 --> NB
    S2 --> DF
    NB --> LH[(sharepoint_bronze_lh
schema-enabled
Bronze Lakehouse)]
    DF --> LH

    S3 -.->|shortcut| FILES[Files / telefoncia_staging
non-Delta]
    FILES -.->|reference| LH

    LH -->|consumed by| SIL[Silver Lakehouse]

    classDef src fill:#e3f2fd,stroke:#1976d2,stroke-width:1px
    classDef orc fill:#fff3cd,stroke:#b85c00,stroke-width:1px
    classDef brz fill:#f4a261,stroke:#b85c00,stroke-width:1px,color:#000
    classDef sil fill:#c0c0c0,stroke:#555,stroke-width:1px
    classDef files fill:#e8f5e9,stroke:#2e7d32,stroke-width:1px

    class S1,S2,S3 src
    class NB,DF orc
    class LH brz
    class SIL sil
    class FILES files

Two storage paths in this Lakehouse

Path	Format	Visible under	Typical content
Tables	Delta	Tables section	Notebook-/Dataflow-ingested SharePoint data
Files	Excel / non-Delta	Files section	Telefónica Excel-Shortcuts in telefoncia_staging

List of tables

Die Live-Tabellen-Liste wird in SharePoint ueber einen eingebetteten Power-BI-Report angezeigt. Im XWiki-Staging ist dieser Embed nicht reproduzierbar (Authentifizierung gegen den Tenant erforderlich).

Hinweis: Die aktuelle, live aktualisierte Tabellenliste ist im Original-SharePoint-Page-Embed verfuegbar:
Report: Tables in sharepoint_bronze_lh (Power BI)
Beim Transfer ins Ziel-Wiki: Embed-Mechanismus pruefen (vermutlich Unknown macro: powerbi. Click on this message for details.
The [powerbi] macro is not in the list of registered macros. Verify the spelling or contact your administrator.

Operational notes

Schedule: Refresh laeuft an Wochentagen — anders als die taeglich um 04:xx laufenden BMD / Rimo / H3A / Board Pipelines.
Schema-aware: Tabellen liegen in Quellsystem-benannten Schemas, nicht in dbo.
Non-Delta-Daten: Excel-Files (Telefonica) sind ueber ADLS-Shortcuts als Files eingebunden, nicht als Tables.
Access: Restricted to the Fabric team.

SharePoint Bronze Lakehouse

SharePoint Bronze Lakehouse

Overview

About this Lakehouse

Orchestration

Two storage paths in this Lakehouse

List of tables

Operational notes

Related pages

Verwandte Themen