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.
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 a change will break
Open source. Emergent column-level lineage across SQL and Python assets.