What problem does it solve?
When ingesting uploaded dbt projects into ktx, raw dbt YAML (models, sources, column tests) must be translated into semantic-layer overlays without inventing columns, joins, or measures that do not exist in the actual warehouse. This Skill provides the mapping rules and verification protocol to do that accurately.
Core Features & Use Cases
- dbt-to-SL mapping: Converts
models: and sources: entries into semantic-layer overlays, resolving identifier fields and matching manifest-backed tables on the correct warehouse connection.
- Test metadata hints: Translates
data_tests (not_null, unique, accepted_values, relationships) into short column description hints and validated joins.
- Identifier verification protocol: Requires
discover_data, entity_details, and sql_execution probes before writing any schema.table reference, preventing fictional identifiers.
- Use Case: A user uploads a dbt project bundle containing
schema.yml files under models/; the agent uses this Skill to write validated SL overlays and wiki notes grounded in the real warehouse schema.
Quick Start
Load the dbt_ingest skill and map the uploaded dbt schema.yml files into ktx semantic-layer overlays verified against the warehouse.