Wiki source code of Board Bronze Lakehouse
Version 1.1 by Dimitri Rupp on 2026/06/11 09:16
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | {{box cssClass="floatinginfobox" title="**On this page**"}} | ||
| 2 | {{toc/}} | ||
| 3 | {{/box}} | ||
| 4 | |||
| 5 | = Board Bronze Lakehouse = | ||
| 6 | |||
| 7 | {{info}} | ||
| 8 | **Source system:** Board — planning and controlling database | ||
| 9 | **Stage:** Bronze (raw landing zone) | ||
| 10 | **Owner:** Fabric team (restricted access) | ||
| 11 | {{/info}} | ||
| 12 | |||
| 13 | == Overview == | ||
| 14 | |||
| 15 | |=(% style="width:80px" %)📋 **What**|Data from **Board** — landed in the Bronze layer as-is, without transformations. | ||
| 16 | |=(% style="width:80px" %)🔄 **How**|**Gen2 Dataflow** consuming the Board **API**. | ||
| 17 | |=(% style="width:80px" %)🔐 **Who**|Access is **restricted to the Fabric team**. | ||
| 18 | |||
| 19 | == Orchestration == | ||
| 20 | |||
| 21 | |=Property|=Value | ||
| 22 | |🛠️ Tool|Gen2 Dataflow | ||
| 23 | |🆔 Name|(% style="font-family:monospace" %)get_Board_API(%%) | ||
| 24 | |ℹ️ Function|Copy data from Board using API | ||
| 25 | |⚡ Trigger|On refresh schedule | ||
| 26 | |🕞 Time|04:30 AM daily | ||
| 27 | |||
| 28 | {{mermaid}} | ||
| 29 | flowchart LR | ||
| 30 | BOARD[Board<br/>API endpoint] -->|get_Board_API<br/>Gen2 Dataflow| LH[(board_bronze_lh<br/>Bronze Lakehouse)] | ||
| 31 | LH -->|consumed by| SIL[Silver Lakehouse] | ||
| 32 | TRG[⚡ Trigger:<br/>refresh schedule<br/>04:30 AM daily] -.->|schedules| BOARD | ||
| 33 | |||
| 34 | classDef src fill:#e3f2fd,stroke:#1976d2,stroke-width:1px | ||
| 35 | classDef brz fill:#f4a261,stroke:#b85c00,stroke-width:1px,color:#000 | ||
| 36 | classDef sil fill:#c0c0c0,stroke:#555,stroke-width:1px | ||
| 37 | classDef trg fill:#fff3cd,stroke:#b85c00,stroke-width:1px | ||
| 38 | |||
| 39 | class BOARD src | ||
| 40 | class LH brz | ||
| 41 | class SIL sil | ||
| 42 | class TRG trg | ||
| 43 | {{/mermaid}} | ||
| 44 | |||
| 45 | == List of tables == | ||
| 46 | |||
| 47 | |=Name|=Schema | ||
| 48 | |(% style="font-family:monospace" %)board_project_overview(%%)|dbo | ||
| 49 | |||
| 50 | {{info}} | ||
| 51 | Bisher ist eine einzige Tabelle aus Board angebunden — die **Projekt-Uebersicht**. Weitere Tabellen koennen ergaenzt werden, sobald sie aus dem Quellsystem benoetigt werden. | ||
| 52 | {{/info}} | ||
| 53 | |||
| 54 | == Why Gen2 Dataflow for Board? == | ||
| 55 | |||
| 56 | Im Gegensatz zu BMD, Rimo oder H3A wird Board nicht ueber eine Datenbank-Verbindung, sondern ueber eine **HTTP-API** angesprochen. Gen2 Dataflows sind dafuer ideal, weil sie: | ||
| 57 | |||
| 58 | * **Power Query** mitbringen (REST-Connector, JSON-Parsing, Authentifizierung). | ||
| 59 | * **Low-Code** sind — vorhandenes Power-Query-Wissen aus Power BI ist 1:1 nutzbar. | ||
| 60 | * sich gut **schedulen** lassen und in das Bronze-Lakehouse schreiben. | ||
| 61 | |||
| 62 | == Operational notes == | ||
| 63 | |||
| 64 | * **Schedule:** Der Refresh laeuft taeglich um 04:30 Uhr. | ||
| 65 | * **No transformations:** Bronze-Standard — Tabelle so wie aus dem Board-API geliefert. | ||
| 66 | * **Access:** Restricted to the Fabric team. | ||
| 67 | |||
| 68 | == Related pages == | ||
| 69 | |||
| 70 | * [[Bronze Lakehouse (Hub)>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.WebHome]] | ||
| 71 | * [[Fabric Lakehouse Hub>>doc:IT-Wiki.01-Data.Processing.Lakehouse.WebHome]] | ||
| 72 | * [[Microsoft Fabric Datenarchitektur im SPL>>doc:IT-Wiki.01-Data.Microsoft-Fabric-Datenarchitektur-im-SPL.WebHome]] | ||
| 73 | * [[Silver Lakehouse>>doc:IT-Wiki.01-Data.Processing.Lakehouse.Fabric-Silver-Lakehouse.WebHome]] | ||
| 74 | * [[Gold Lakehouse>>doc:IT-Wiki.01-Data.Processing.Lakehouse.Fabric-Gold-Lakehouse.WebHome]] | ||
| 75 | |||
| 76 | ---- | ||
| 77 | |||
| 78 | {{info}} | ||
| 79 | **Migration footer** | ||
| 80 | **Source:** [[Board Bronze Lakehouse (SharePoint)>>url:https://spltele.sharepoint.com/sites/WikiPowerBI/SitePages/Board-Bronze-Lakehouse.aspx]] | ||
| 81 | **Original author:** Bukkerji Sreejith — Sreejith.Bukkerji@spl-tele.com | ||
| 82 | **Original last-modified:** 2025-10-15 | ||
| 83 | **Migration date:** 2026-05-24 | ||
| 84 | **Migrated by:** Dimitri Rupp via ClaudeAI | ||
| 85 | **Notes:** EN-Original preserved; 3-card-WHAT-HOW-WHO layout converted to summary table; Mermaid API-zu-Bronze-Diagramm ergaenzt; Knowledge-Note "Why Gen2 Dataflow for Board?" hinzugefuegt (Abgrenzung zu BMD/Rimo/H3A). | ||
| 86 | {{/info}} | ||
| 87 | |||
| 88 | |||
| 89 | ---- | ||
| 90 | |||
| 91 | == Verwandte Themen == | ||
| 92 | |||
| 93 | //Kuratiert — kann direkt im Editor ergänzt werden:// | ||
| 94 | |||
| 95 | * [[BMD Bronze Lakehouse>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.BMD-Bronze-Lakehouse.WebHome]] | ||
| 96 | * [[H3A Bronze Lakehouse>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.H3A-Bronze-Lakehouse.WebHome]] | ||
| 97 | * [[Rimo Lakehouse>>doc:IT-Wiki.01-Data.Ingestion.Bronze-Lakehouse.Rimo-Lakehouse.WebHome]] | ||
| 98 | |||
| 99 | {{include reference="IT-Wiki.Makros.Verwandte-Themen.WebHome"/}} | ||
| 100 | |||
| 101 | ---- | ||
| 102 | **Status:** Migriert — Team-Review ausstehend · **Owner:** //(festlegen)// · **Letzter Review:** 2026-06-11 |