Which Redshift columns are never used downstream?
Lineage shows Redshift columns with no downstream consumers, so you can safely deprecate them and shrink your models.
Command
bruin lineageDefined in
SQL + YAML
Works with
Redshift + Bruin CLI
What you get
Dead-column detectionemergentcolumn-level
How it works in code
$ bruin lineage ./pipeline --downstream # redshiftRun bruin lineage and you see the full Redshift 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 a change will break
Open source. Emergent column-level lineage across SQL and Python assets.