How do I trace a Snowflake metric back to its raw sources?
Column-level lineage maps each Snowflake 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
Snowflake + Bruin CLI
What you get
Metric tracingemergentcolumn-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 warehouseFind unused columns in Snowflake models
Which Snowflake columns are never used downstream?
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
Bruin CLI and ingestr are on GitHub.
A demo walks through your own data.