{"repo":"jchesch/sap-hierarchy-flattener","free":true,"listed":false,"github":"https://github.com/jchesch/sap-hierarchy-flattener","clone":"git clone https://github.com/jchesch/sap-hierarchy-flattener.git","description":"ETL (transformation logic) and target data model for flattening SAP hierarchies via SQL (current syntax is Snowflake).","language":"PLpgSQL","stars":22,"topics":["data-model","etl","hierarchies","sap","snowflake","snowflakedb"],"license":null,"category":"data-pipelines","readme_excerpt":"- TreeHouse - Disclaimer - Introduction - Prerequisites - Goals - Data Model - Source - Data Dictionary - SETHEADER - SETNODE - SETLEAF - Data Quality - Duplicates \\& Multi-Parent - Heterogeneous Hierarchies - Target - Data Dictionary - Tables - STG\\ HIER - HIER\\ FLAT - HIER\\ PARENT\\ CHILD - Views - ETL - Overview - Performance Considerations - Declarative logic - Joins - Control Flow - Parallel Orchestration - Design Decisions - Try It Out - 1. Create source tables - 2. Load test data - 3. Create target data model - 4. Create ETL functions - 5. Load sample config data - 6. Generate hierarchies - 7. Query the results - Extending TreeHouse TreeHouse TreeHouse™ is an open source data product that models, transforms and flattens hierarchical data (i.e. tree structures) for data warehouse / lakehouse systems, primarily to simplify and accelerate BI and reporting use cases that require hierarchies. TreeHouse is currently scoped to SAP hierarchies in particular. Disclaimer The TreeHouse project is an independent open-source initiative and is not affiliated with, endorsed, or sponsored by SAP SE or its affiliates. SAP® and other SAP product names are trademarks or registered trademarks of SAP SE (or its affiliates) in Germany and other countries. Introduction TreeHouse™ is an open source data product that models, transforms and flattens hierarchical data (i.e. tree structures) for data warehouse / lakehouse systems, primarily to simplify and accelerate BI and reporting use cases tha","default_branch":null,"files":null,"tree":[],"storefront":"/r/jchesch","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jchesch/sap-hierarchy-flattener/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}