Which Snowflake columns are never used downstream?
Lineage shows Snowflake 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
Snowflake + Bruin CLI
What you get
Dead-column detectionemergentcolumn-level
How it works in code
$ bruin lineage ./pipeline --downstream # snowflakeRun bruin lineage and you see the full Snowflake 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 warehouseDebug a wrong number on Snowflake with lineage
A Snowflake metric looks wrong. Where did it go bad?
Know what breaks before you ship it
Open source. Column-level lineage parsed from your SQL, with no manual mapping.