kairos-medallion-projection

What problem does it solve?

This skill automates the creation of a dbt Core project that implements bronze-to-silver transformations driven by domain ontologies, bronze vocabularies, and source-to-domain mappings. It provides a reproducible, ontology-driven framework to generate staging and silver models with integrated SHACL tests, enabling faster analytics pipeline development.

Core Features & Use Cases

• Ontology-driven dbt project generation for bronze-to-silver pipelines using domain ontologies, source vocabulary, and SKOS mappings.
• Automatic creation of staging models and silver domain models structured under a standard medallion output layout.
• Incorporation of SHACL-derived tests into the dbt workflow for data quality validation.
• Use Case: accelerate multi-domain analytics projects by reusing a single ontology-driven projection to deploy consistent pipelines across domains.

Quick Start

Run the medallion projection to generate a dbt Core project that transforms bronze data into silver domain tables.