H3A Bronze Lakehouse

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

On this page

H3A Bronze Lakehouse

H3A Bronze Lakehouse

Source system: H3A — third-party operational system
Stage: Bronze (raw landing zone)
Owner: Fabric team (restricted access)

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.

H3A Bronze Lakehouse

H3A Bronze Lakehouse

Overview

Orchestration

List of tables

Functional groups (orientation)

Operational notes

Related pages

Verwandte Themen