Skip to Content

Rimo Lakehouse

Version 3.1 by Dimitri Rupp on 2026/06/11 09:18
Warning
For security reasons, the document is displayed in restricted mode as it is not the current version. There may be differences and errors due to this.
On this page

Rimo Lakehouse

Information

Source system: Rimo — SPL Tele's own software product (DWH-Layer)
Stage: Bronze (raw landing zone)
Owner: Fabric team (restricted access)

Overview

📋 WhatTables from the Rimo Data Warehouse. Acts as the landing zone for all Rimo-related data. No transformations are carried out here.
🔄 HowData is copied from the Rimo DWH via Fabric Data Pipelines.
🔐 WhoAccess is restricted to the Fabric team.

How data is ingested

Data from the Rimo source system is ingested into the rimo_bronze_lh Lakehouse, following SPL's bronze-layer convention of preserving raw data with minimal intervention. As with all bronze Lakehouses, no transformations are applied during ingestion — ensuring that the data reflects the source system as closely as possible.

However, due to type incompatibilities between the source schema and Lakehouse constraints, certain columns may be stored using alternate data types. These adjustments are system-driven and occur by default to maintain ingestion continuity.

To ensure pipeline resilience, the orchestration process is designed to skip non-compatible rows rather than fail the entire ingestion job. This prevents a single malformed record from disrupting ingestion across multiple tables.

Whenever a row is skipped due to schema or type mismatches, the event is logged in a dedicated folder within the fabric-logs directory of the northlakepmo2 Azure Data Lake Storage account. These logs provide traceability for data quality issues and support downstream reconciliation and monitoring.

flowchart LR
    RIMO[(Rimo DWH
source system)] -->|Fabric Data Pipeline| LH[(rimo_bronze_lh
Bronze Lakehouse)]
    LH -->|consumed by| SIL[Silver Lakehouse]
    LH -.->|skipped rows| LOGS[(northlakepmo2
fabric-logs)]

    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 log fill:#fff3cd,stroke:#b85c00,stroke-width:1px

    class RIMO src
    class LH brz
    class SIL sil
    class LOGS log

Naming convention

When the rimo_bronze_lh Lakehouse was provisioned, Microsoft Fabric had not yet introduced support for custom schemas within Lakehouses. At that time, all tables were automatically assigned to the default dbo schema, regardless of their source schema in the Rimo Data Warehouse.

As a result, tables originating from Rimo's public, dim, and custom schemas were all ingested into the Lakehouse under the dbo schema. To preserve schema lineage and avoid ambiguity, a prefix-based naming convention was adopted.

For example:

  • public_sdmsalesorder
  • dim_sdmperson_historic
  • custom_sdmperson_fte

This approach ensures that:

  • Source-schema context is retained despite the schema flattening.
  • Governance and reconciliation processes remain schema-aware.
Warning

Hinweis zu Tabellen-Namen: Einige Eintraege weichen vom sdm*-Muster ab (z.B. sdibsssalesordergroup). Diese sind 1:1 wie im Quellsystem uebernommen und werden erst nach Ruecksprache mit dem Fabric-Team angepasst.

Schema overview

The 94 tables in rimo_bronze_lh come from three origin schemas:

PrefixOrigin schemaCount (≈)Typical content
custom_*Rimo custom schema2Customer-specific calculations (FTE, progress logic)
dim_*Rimo dim schema1Historic dimension (person history)
public_*Rimo public schema91Operational core: SDM/BSS, persons, projects, materials, travel, finance, storage, time tracking

List of tables in rimo_bronze_lh

Source table in RimoTable name in rimo_bronze_lh
custom.sdmmilestoneitem_progress_manuell_diff_newlogiccustom_sdmmilestoneitem_progress_manuell_diff_newlogic
custom.sdmperson_ftecustom_sdmperson_fte
dim.sdmperson_historicdim_sdmperson_historic
public.otbpersonalstoragepublic_otbpersonalstorage
public.otbrepairstoragepublic_otbrepairstorage
public.otbstoragedepotpublic_otbstoragedepot
public.otbstoragespacepublic_otbstoragespace
public.sdmactivitypublic_sdmactivity
public.sdmaddresslocationpublic_sdmaddresslocation
public.sdmchangerequestcmpublic_sdmchangerequestcm
public.sdmcompanypublic_sdmcompany
public.sdmcreditorpublic_sdmcreditor
public.sdmcurrencypublic_sdmcurrency
public.sdmcustomerpurchaseorderpublic_sdmcustomerpurchaseorder
public.sdmcustomerslapublic_sdmcustomersla
public.sdmdebitorpublic_sdmdebitor
public.sdmdynamictenantattributedescriptionpublic_sdmdynamictenantattributedescription
public.sdmfaultpublic_sdmfault
public.sdmfaultteampublic_sdmfaultteam
public.sdmhotellocationpublic_sdmhotellocation
public.sdminboundstockorderpublic_sdminboundstockorder
public.sdmincidentpublic_sdmincident
public.sdminvoicepublic_sdminvoice
public.sdminvoiceapprovalpublic_sdminvoiceapproval
public.sdminvoiceassignmentpublic_sdminvoiceassignment
public.sdmlistelementpublic_sdmlistelement
public.sdmlogisticscanitempublic_sdmlogisticscanitem
public.sdmmasteritempublic_sdmmasteritem
public.sdmmasteritemcategorypublic_sdmmasteritemcategory
public.sdmmastertoolpublic_sdmmastertool
public.sdmmaterialpublic_sdmmaterial
public.sdmmaterialchangeorderpublic_sdmmaterialchangeorder
public.sdmmanufacturerpublic_sdmmanufacturer
public.sdmmilestonepublic_sdmmilestone
public.sdmmilestoneitempublic_sdmmilestoneitem
public.sdmmonthpublic_sdmmonth
public.sdmofferitempoolmgpublic_sdmofferitempoolmg
public.sdmofferitempoolsg1public_sdmofferitempoolsg1
public.sdmofferitempoolsg2public_sdmofferitempoolsg2
public.sdmofferitemservicepublic_sdmofferitemservice
public.sdmofferitemservicetemplatepublic_sdmofferitemservicetemplate
public.sdmoffdutyentrypublic_sdmoffdutyentry
public.sdmondutyentrypublic_sdmondutyentry
public.sdmpaymenttermpublic_sdmpaymentterm
public.sdmpersonpublic_sdmperson
public.sdmprocesscontainerpublic_sdmprocesscontainer
public.sdmproductivizationentrypublic_sdmproductivizationentry
public.sdmproductivizationmonthpublic_sdmproductivizationmonth
public.sdmproductticketpublic_sdmproductticket
public.sdmprojectpurchaseorderpublic_sdmprojectpurchaseorder
public.sdmprojectpurchaseorderitempublic_sdmprojectpurchaseorderitem
public.sdmprojectpurchaseorderitemtemplatepublic_sdmprojectpurchaseorderitemtemplate
public.sdmprovisioncalculationitempublic_sdmprovisioncalculationitem
public.sdmresourcelinkpublic_sdmresourcelink
public.sdmrootcausepublic_sdmrootcause
public.sdmsalaryabsenttypepublic_sdmsalaryabsenttype
public.sdmsalarynegativetypepublic_sdmsalarynegativetype
public.sdmsalarytypepublic_sdmsalarytype
public.sdmsalesinvoicepublic_sdmsalesinvoice
public.sdmsalesorderpublic_sdmsalesorder
public.sdibsssalesordergrouppublic_sdibsssalesordergroup
public.sdmserviceitempoolpublic_sdmserviceitempool
public.sdmserviceorderpublic_sdmserviceorder
public.sdmslareasonpublic_sdmslareason
public.sdmsubticketpublic_sdmsubticket
public.sdmteampublic_sdmteam
public.sdmtoolpublic_sdmtool
public.sdmtravelflightitempublic_sdmtravelflightitem
public.sdmtravelaccommodationitempublic_sdmtravelaccommodationitem
public.sdmtravelcaritempublic_sdmtravelcaritem
public.sdmtravelorderpublic_sdmtravelorder
public.sdmtravelreceiptpublic_sdmtravelreceipt
public.sdmtravelrequestpublic_sdmtravelrequest
public.sdmtraveltrainitempublic_sdmtraveltrainitem
public.sdmwtrprojectpublic_sdmwtrproject
public.sdmwtrprojectgrouppublic_sdmwtrprojectgroup
public.sdmworkorderpublic_sdmworkorder
public.sdmworkpackagetypepublic_sdmworkpackagetype
public.splallowanceentrypublic_splallowanceentry
public.splworkentrypublic_splworkentry
public.sdmbsscartitempublic_sdmbsscartitem
public.sdmbssdemandorderpublic_sdmbssdemandorder
public.sdmbssmanualaccountingorderpublic_sdmbssmanualaccountingorder
public.sdmbssmaterialaccountingorderpublic_sdmbssmaterialaccountingorder
public.sdmbssoutboundstockorderpublic_sdmbssoutboundstockorder
public.sdmbssprojectcontrollingitempublic_sdmbssprojectcontrollingitem
public.sdmbssreturnorderpublic_sdmbssreturnorder
public.sdmbssstockquerymanagerpublic_sdmbssstockquerymanager
public.sdmbsstravelaccountingorderpublic_sdmbsstravelaccountingorder
public.sdmbssworkpackagepublic_sdmbssworkpackage
public.sdmbsswpmilestonepublic_sdmbsswpmilestone
public.sdmstatuspublic_sdmstatus
public.sdmstandardproductioncostgrouppublic_sdmstandardproductioncostgroup
public.sdmstandardproductioncostpublic_sdmstandardproductioncost

Operational notes

  • No transformations: Tables in Bronze stay as close to source as Fabric allows. Cleansing happens in Silver.
  • Resilience: Single non-compatible rows are skipped, not failed. The job keeps running.
  • Traceability: Skipped rows are logged in northlakepmo2 → fabric-logs for downstream reconciliation.
  • Access: Restricted to the Fabric team. Power-BI-Reports consume from Silver/Gold, not directly from Bronze.

Related pages

Information

Migration footer
Source: Rimo Lakehouse (SharePoint)
Original author: Bukkerji Sreejith — Sreejith.Bukkerji@spl-tele.com
Original last-modified: 2025-10-09
Migration date: 2026-05-24
Migrated by: Dimitri Rupp via ClaudeAI
Notes: EN-Original preserved; 3-card-WHAT-HOW-WHO layout converted to summary table; 3 long paragraphs about ingestion + naming retained 1:1; Mermaid ingestion diagram (incl. fabric-logs skipped-row path) added; 94 table mappings extracted and presented as monospaced table; schema-prefix overview added for navigation.

Verwandte Themen

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

Failed to execute the [velocity] macro. Cause: [The execution of the [velocity] script macro is not allowed in [xwiki:IT-Wiki.Makros.Verwandte-Themen.WebHome]. Check the rights of its last author or the parameters if it's rendered from another script.]. Click on this message for details.

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