Skip to Content

SharePoint Bronze Lakehouse

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

SharePoint Bronze Lakehouse

Information

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

Overview

📋 WhatData from various SharePoint sites in SPL — landed in Bronze without transformations.
🔄 HowNotebooks and Dataflows (Python / Gen2).
🔐 WhoAccess 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.

Information

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

PropertyValue
🛠️ ToolPython Notebooks (primary), Gen2 Dataflows
ℹ️ FunctionCopy data from SharePoint files to Lakehouse
⚡ TriggerOn refresh schedule
🕞 TimeWeek 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

PathFormatVisible underTypical content
TablesDeltaTables sectionNotebook-/Dataflow-ingested SharePoint data
FilesExcel / non-DeltaFiles sectionTelefó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).

Warning

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.

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.

Related pages

Verwandte Themen

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

Automatisch vorgeschlagen über gemeinsame Tags (architektur, fabric): 

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