Which MotherDuck columns are never used downstream?
Lineage shows MotherDuck columns with no downstream consumers, so you can safely deprecate them and shrink your models. 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, and the browser.
Command
bruin lineageDefined in
SQL + YAML
Works with
MotherDuck + Bruin CLI
What you get
Dead-column detectionemergentcolumn-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
Open source. Column-level lineage parsed from your SQL, with no manual mapping.