Metricflow Ingest

If you're migrating a dbt MetricFlow semantic layer to ktx, this skill does the heavy lifting. It reads your semantic_models and metrics YAMLs, flattens extends inheritance chains, maps MetricFlow measure types (simple, derived, ratio, cumulative, conversion) to ktx primitives, and resolves ref() calls to actual tables. The mapping table alone is worth loading this for. It handles the tricky bits like foreign key entities becoming joins, filtered metrics becoming new measures, and cumulative metrics degrading gracefully to standalone SQL sources when ktx has no native equivalent. Four worked examples walk through real conversions. Load it whenever you drop MetricFlow YAML into the conversation and need ktx sources out the other end.

GitHub stars: 1.1K
last updated: Jun 11, 2026

View on GitHub

Install

$ npx -y skills add kaelio/ktx --skill metricflow_ingest --agent claude-code

Installs into .claude/skills of the current project.

Files

MetricFlow to ktx Semantic Layer

A MetricFlow semantic_model maps to an SL source; MetricFlow measures map to ktx measures; MetricFlow entities map to ktx joins; MetricFlow metrics (top-level) map to ktx measures OR to cross-model derived measures. Files in one WorkUnit are ALWAYS part of the same logical entity (a connected component, possibly spanning extends: + cross-model metric refs). Flatten inheritance and cross-file references at write time.