How do I trace a MotherDuck metric back to its raw sources?
Column-level lineage maps each MotherDuck output column to the exact upstream columns it depends on, so you can trace any metric to its source. Bruin does this in one platform: ingestion, SQL and Python pipelines, quality checks, lineage, and an AI data analyst that answers in Slack, Microsoft Teams, Google Chat, WhatsApp, Discord, Telegram, email and the browser.
Command
bruin lineageDefined in
SQL + YAML
Works with
MotherDuck + Bruin CLI
What you get
Metric tracingemergentcolumn-level
How it works in code
$ bruin lineage ./pipeline --downstream # motherduckRun bruin lineage and you see the full MotherDuck column graph before changing anything.
Related use cases
Lineage by warehouse
Run impact analysis on Snowflake before a schema change
What breaks on Snowflake if I drop or rename a column?
Lineage by warehouseTrace a Snowflake metric to its source columns
How do I trace a Snowflake metric back to its raw sources?
Lineage by warehouseFind unused columns in Snowflake models
Which Snowflake columns are never used downstream?
Know what breaks before you ship it
Bruin CLI and ingestr are on GitHub.
A demo walks through your own data.