H3A Bronze Lakehouse
Last modified by Dimitri Rupp on 2026/06/11 09:30
On this page
H3A Bronze Lakehouse
Overview
| 📋 What | Tables from the H3A Data Warehouse. Acts as the landing zone for all H3A-related data. No transformations are carried out here. |
|---|---|
| 🔄 How | Data is copied via Fabric Data Pipelines. |
| 🔐 Who | Access is restricted to the Fabric team. |
Orchestration
| Property | Value |
|---|---|
| 🛠️ Tool | Fabric Data Pipeline |
| 🆔 Pipeline name | getH3ADWH |
| ℹ️ Function | Copy data from H3A DWH to h3a_bronze_lh |
| ⚡ Trigger | 0400_Daily_h3a pipeline |
| 🕞 Time | 04:00 AM daily |
flowchart LR
H3A[(H3A DWH
Source database)] -->|getH3ADWH
Fabric Data Pipeline| LH[(h3a_bronze_lh
Bronze Lakehouse)]
LH -->|consumed by| SIL[Silver Lakehouse]
TRG[⚡ Trigger:
0400_Daily_h3a
04:00 AM daily] -.->|schedules| H3A
classDef src fill:#e3f2fd,stroke:#1976d2,stroke-width:1px
classDef brz fill:#f4a261,stroke:#b85c00,stroke-width:1px,color:#000
classDef sil fill:#c0c0c0,stroke:#555,stroke-width:1px
classDef trg fill:#fff3cd,stroke:#b85c00,stroke-width:1px
class H3A src
class LH brz
class SIL sil
class TRG trg
List of tables
The h3a_bronze_lh currently exposes 13 tables. All sit in the dbo schema.
| Name | Schema |
|---|---|
| public_otbstockorder | dbo |
| public_otbstoragedepot | dbo |
| public_sdmbssoutboundstockorder | dbo |
| public_sdmcustomizedstockorder | dbo |
| public_sdminboundstockorder | dbo |
| public_sdminboundstockordertype | dbo |
| public_sdmlistelement | dbo |
| public_sdmlogisticscanitem | dbo |
| public_sdmmatdemandorder | dbo |
| public_sdmmobilelocation | dbo |
| public_sdmoutboundstockorder | dbo |
| public_sdmperson | dbo |
| public_sdmpurchaseorder | dbo |
Functional groups (orientation)
| Prefix / pattern | Area | Typical content |
|---|---|---|
| public_otb* | Operational tables (Storage / Stock Orders) | Storage depots, stock orders |
| public_sdmbss* | BSS — Business-Support | Outbound stock orders |
| public_sdminbound* | Inbound stock | Inbound orders + types |
| public_sdmoutbound* | Outbound stock | Outbound orders |
| public_sdmcustomized* | Customer-specific | Customized stock orders |
| public_sdmlogisticscanitem | Logistics | Scan items |
| public_sdmmatdemandorder | Material | Material demand orders |
| public_sdmmobilelocation | Mobile | Mobile location data |
| public_sdmperson | People | Person master |
| public_sdmpurchaseorder | Purchase | Purchase orders |
| public_sdmlistelement | Reference data | Lookup / list elements |
Operational notes
- Schedule: Die Pipeline 0400_Daily_h3a laeuft taeglich um 04:00 Uhr — als erste Pipeline am Morgen (vor BMD um 04:35 und Board um 04:30).
- No transformations: Bronze-Standard.
- Access: Restricted to the Fabric team. Power-BI-Reports konsumieren aus Silver/Gold.
Related pages
- Bronze Lakehouse (Hub)
- Fabric Lakehouse Hub
- Microsoft Fabric Datenarchitektur im SPL
- Silver Lakehouse
- Gold Lakehouse
Verwandte Themen
Kuratiert — kann direkt im Editor ergänzt werden://
Automatisch vorgeschlagen über gemeinsame Tags (architektur, fabric):
- BMD Bronze Lakehouse
- Board Bronze Lakehouse
- Rimo Lakehouse
- SharePoint Bronze Lakehouse
- Bronze Lakehouse
- Microsoft-Fabric-Datenarchitektur im SPL
Status: Migriert — Team-Review ausstehend · Owner: (festlegen) · Letzter Review: 2026-06-11