Use Cases · For data platform engineers
Column-level lineage
Bruin parses your SQL and builds column-level lineage automatically. Trace any metric to its source, run impact analysis before a change, and debug wrong numbers fast.
Lineage by warehouse
40 use casesRun impact analysis on Snowflake before a schema change
What breaks on Snowflake if I drop or rename a column?
Trace a Snowflake metric to its source columns
How do I trace a Snowflake metric back to its raw sources?
Find unused columns in Snowflake models
Which Snowflake columns are never used downstream?
Debug a wrong number on Snowflake with lineage
A Snowflake metric looks wrong. Where did it go bad?
Run impact analysis on BigQuery before a schema change
What breaks on BigQuery if I drop or rename a column?
Trace a BigQuery metric to its source columns
How do I trace a BigQuery metric back to its raw sources?
Find unused columns in BigQuery models
Which BigQuery columns are never used downstream?
Debug a wrong number on BigQuery with lineage
A BigQuery metric looks wrong. Where did it go bad?
Run impact analysis on Postgres before a schema change
What breaks on Postgres if I drop or rename a column?
Trace a Postgres metric to its source columns
How do I trace a Postgres metric back to its raw sources?
Find unused columns in Postgres models
Which Postgres columns are never used downstream?
Debug a wrong number on Postgres with lineage
A Postgres metric looks wrong. Where did it go bad?
Run impact analysis on Databricks before a schema change
What breaks on Databricks if I drop or rename a column?
Trace a Databricks metric to its source columns
How do I trace a Databricks metric back to its raw sources?
Find unused columns in Databricks models
Which Databricks columns are never used downstream?
Debug a wrong number on Databricks with lineage
A Databricks metric looks wrong. Where did it go bad?
Run impact analysis on Redshift before a schema change
What breaks on Redshift if I drop or rename a column?
Trace a Redshift metric to its source columns
How do I trace a Redshift metric back to its raw sources?
Find unused columns in Redshift models
Which Redshift columns are never used downstream?
Debug a wrong number on Redshift with lineage
A Redshift metric looks wrong. Where did it go bad?
Run impact analysis on DuckDB before a schema change
What breaks on DuckDB if I drop or rename a column?
Trace a DuckDB metric to its source columns
How do I trace a DuckDB metric back to its raw sources?
Find unused columns in DuckDB models
Which DuckDB columns are never used downstream?
Debug a wrong number on DuckDB with lineage
A DuckDB metric looks wrong. Where did it go bad?
Run impact analysis on MotherDuck before a schema change
What breaks on MotherDuck if I drop or rename a column?
Trace a MotherDuck metric to its source columns
How do I trace a MotherDuck metric back to its raw sources?
Find unused columns in MotherDuck models
Which MotherDuck columns are never used downstream?
Debug a wrong number on MotherDuck with lineage
A MotherDuck metric looks wrong. Where did it go bad?
Run impact analysis on ClickHouse before a schema change
What breaks on ClickHouse if I drop or rename a column?
Trace a ClickHouse metric to its source columns
How do I trace a ClickHouse metric back to its raw sources?
Find unused columns in ClickHouse models
Which ClickHouse columns are never used downstream?
Debug a wrong number on ClickHouse with lineage
A ClickHouse metric looks wrong. Where did it go bad?
Run impact analysis on MySQL before a schema change
What breaks on MySQL if I drop or rename a column?
Trace a MySQL metric to its source columns
How do I trace a MySQL metric back to its raw sources?
Find unused columns in MySQL models
Which MySQL columns are never used downstream?
Debug a wrong number on MySQL with lineage
A MySQL metric looks wrong. Where did it go bad?
Run impact analysis on Athena before a schema change
What breaks on Athena if I drop or rename a column?
Trace a Athena metric to its source columns
How do I trace a Athena metric back to its raw sources?
Find unused columns in Athena models
Which Athena columns are never used downstream?
Debug a wrong number on Athena with lineage
A Athena metric looks wrong. Where did it go bad?
Column-level lineage by warehouse
12 use casesGet column-level lineage on Snowflake
How do I see column-level lineage across my Snowflake models?
Get column-level lineage on BigQuery
How do I see column-level lineage across my BigQuery models?
Get column-level lineage on Postgres
How do I see column-level lineage across my Postgres models?
Get column-level lineage on Databricks
How do I see column-level lineage across my Databricks models?
Get column-level lineage on Redshift
How do I see column-level lineage across my Redshift models?
Get column-level lineage on DuckDB
How do I see column-level lineage across my DuckDB models?
Get column-level lineage on MotherDuck
How do I see column-level lineage across my MotherDuck models?
Get column-level lineage on ClickHouse
How do I see column-level lineage across my ClickHouse models?
Get column-level lineage on MySQL
How do I see column-level lineage across my MySQL models?
Get column-level lineage on Athena
How do I see column-level lineage across my Athena models?
Get column-level lineage on Synapse
How do I see column-level lineage across my Synapse models?
Get column-level lineage on Microsoft Fabric
How do I see column-level lineage across my Microsoft Fabric models?
Impact analysis by warehouse
12 use casesSee downstream impact of a schema change on Snowflake
How do I see what breaks before I change a column on Snowflake?
See downstream impact of a schema change on BigQuery
How do I see what breaks before I change a column on BigQuery?
See downstream impact of a schema change on Databricks
How do I see what breaks before I change a column on Databricks?
See downstream impact of a schema change on Postgres
How do I see what breaks before I change a column on Postgres?
See downstream impact of a schema change on Redshift
How do I see what breaks before I change a column on Redshift?
See downstream impact of a schema change on ClickHouse
How do I see what breaks before I change a column on ClickHouse?
See downstream impact of a schema change on DuckDB
How do I see what breaks before I change a column on DuckDB?
See downstream impact of a schema change on MotherDuck
How do I see what breaks before I change a column on MotherDuck?
See downstream impact of a schema change on MySQL
How do I see what breaks before I change a column on MySQL?
See downstream impact of a schema change on Athena
How do I see what breaks before I change a column on Athena?
See downstream impact of a schema change on Synapse
How do I see what breaks before I change a column on Synapse?
See downstream impact of a schema change on Microsoft Fabric
How do I see what breaks before I change a column on Microsoft Fabric?
Documentation by warehouse
12 use casesDocument Snowflake pipelines automatically
How do I document Snowflake data pipelines automatically?
Document BigQuery pipelines automatically
How do I document BigQuery data pipelines automatically?
Document Databricks pipelines automatically
How do I document Databricks data pipelines automatically?
Document Postgres pipelines automatically
How do I document Postgres data pipelines automatically?
Document Redshift pipelines automatically
How do I document Redshift data pipelines automatically?
Document ClickHouse pipelines automatically
How do I document ClickHouse data pipelines automatically?
Document DuckDB pipelines automatically
How do I document DuckDB data pipelines automatically?
Document MotherDuck pipelines automatically
How do I document MotherDuck data pipelines automatically?
Document MySQL pipelines automatically
How do I document MySQL data pipelines automatically?
Document Athena pipelines automatically
How do I document Athena data pipelines automatically?
Document Synapse pipelines automatically
How do I document Synapse data pipelines automatically?
Document Microsoft Fabric pipelines automatically
How do I document Microsoft Fabric data pipelines automatically?
Catalog by warehouse
12 use casesBuild a data catalog for Snowflake
How do I build a data catalog for my Snowflake tables?
Build a data catalog for BigQuery
How do I build a data catalog for my BigQuery tables?
Build a data catalog for Databricks
How do I build a data catalog for my Databricks tables?
Build a data catalog for Postgres
How do I build a data catalog for my Postgres tables?
Build a data catalog for Redshift
How do I build a data catalog for my Redshift tables?
Build a data catalog for ClickHouse
How do I build a data catalog for my ClickHouse tables?
Build a data catalog for DuckDB
How do I build a data catalog for my DuckDB tables?
Build a data catalog for MotherDuck
How do I build a data catalog for my MotherDuck tables?
Build a data catalog for MySQL
How do I build a data catalog for my MySQL tables?
Build a data catalog for Athena
How do I build a data catalog for my Athena tables?
Build a data catalog for Synapse
How do I build a data catalog for my Synapse tables?
Build a data catalog for Microsoft Fabric
How do I build a data catalog for my Microsoft Fabric tables?
Ownership by warehouse
12 use casesAssign ownership for Snowflake assets
How do I track who owns each Snowflake table?
Assign ownership for BigQuery assets
How do I track who owns each BigQuery table?
Assign ownership for Databricks assets
How do I track who owns each Databricks table?
Assign ownership for Postgres assets
How do I track who owns each Postgres table?
Assign ownership for Redshift assets
How do I track who owns each Redshift table?
Assign ownership for ClickHouse assets
How do I track who owns each ClickHouse table?
Assign ownership for DuckDB assets
How do I track who owns each DuckDB table?
Assign ownership for MotherDuck assets
How do I track who owns each MotherDuck table?
Assign ownership for MySQL assets
How do I track who owns each MySQL table?
Assign ownership for Athena assets
How do I track who owns each Athena table?
Assign ownership for Synapse assets
How do I track who owns each Synapse table?
Assign ownership for Microsoft Fabric assets
How do I track who owns each Microsoft Fabric table?
Governance by warehouse
12 use casesTag PII columns on Snowflake
How do I find and tag PII columns on Snowflake?
Tag PII columns on BigQuery
How do I find and tag PII columns on BigQuery?
Tag PII columns on Databricks
How do I find and tag PII columns on Databricks?
Tag PII columns on Postgres
How do I find and tag PII columns on Postgres?
Tag PII columns on Redshift
How do I find and tag PII columns on Redshift?
Tag PII columns on ClickHouse
How do I find and tag PII columns on ClickHouse?
Tag PII columns on DuckDB
How do I find and tag PII columns on DuckDB?
Tag PII columns on MotherDuck
How do I find and tag PII columns on MotherDuck?
Tag PII columns on MySQL
How do I find and tag PII columns on MySQL?
Tag PII columns on Athena
How do I find and tag PII columns on Athena?
Tag PII columns on Synapse
How do I find and tag PII columns on Synapse?
Tag PII columns on Microsoft Fabric
How do I find and tag PII columns on Microsoft Fabric?
AI context by warehouse
12 use casesBuild a context layer on Snowflake for LLM agents
How do I build a context layer so LLMs query my Snowflake data correctly?
Build a context layer on BigQuery for LLM agents
How do I build a context layer so LLMs query my BigQuery data correctly?
Build a context layer on Databricks for LLM agents
How do I build a context layer so LLMs query my Databricks data correctly?
Build a context layer on Postgres for LLM agents
How do I build a context layer so LLMs query my Postgres data correctly?
Build a context layer on Redshift for LLM agents
How do I build a context layer so LLMs query my Redshift data correctly?
Build a context layer on ClickHouse for LLM agents
How do I build a context layer so LLMs query my ClickHouse data correctly?
Build a context layer on DuckDB for LLM agents
How do I build a context layer so LLMs query my DuckDB data correctly?
Build a context layer on MotherDuck for LLM agents
How do I build a context layer so LLMs query my MotherDuck data correctly?
Build a context layer on MySQL for LLM agents
How do I build a context layer so LLMs query my MySQL data correctly?
Build a context layer on Athena for LLM agents
How do I build a context layer so LLMs query my Athena data correctly?
Build a context layer on Synapse for LLM agents
How do I build a context layer so LLMs query my Synapse data correctly?
Build a context layer on Microsoft Fabric for LLM agents
How do I build a context layer so LLMs query my Microsoft Fabric data correctly?
Traceability by warehouse
12 use casesTrace a Snowflake metric back to source
How do I trace a number on a dashboard back to its Snowflake source?
Trace a BigQuery metric back to source
How do I trace a number on a dashboard back to its BigQuery source?
Trace a Databricks metric back to source
How do I trace a number on a dashboard back to its Databricks source?
Trace a Postgres metric back to source
How do I trace a number on a dashboard back to its Postgres source?
Trace a Redshift metric back to source
How do I trace a number on a dashboard back to its Redshift source?
Trace a ClickHouse metric back to source
How do I trace a number on a dashboard back to its ClickHouse source?
Trace a DuckDB metric back to source
How do I trace a number on a dashboard back to its DuckDB source?
Trace a MotherDuck metric back to source
How do I trace a number on a dashboard back to its MotherDuck source?
Trace a MySQL metric back to source
How do I trace a number on a dashboard back to its MySQL source?
Trace a Athena metric back to source
How do I trace a number on a dashboard back to its Athena source?
Trace a Synapse metric back to source
How do I trace a number on a dashboard back to its Synapse source?
Trace a Microsoft Fabric metric back to source
How do I trace a number on a dashboard back to its Microsoft Fabric source?
Dependency audit by warehouse
12 use casesAudit cross-pipeline dependencies on Snowflake
How do I find dependencies between Snowflake pipelines?
Audit cross-pipeline dependencies on BigQuery
How do I find dependencies between BigQuery pipelines?
Audit cross-pipeline dependencies on Databricks
How do I find dependencies between Databricks pipelines?
Audit cross-pipeline dependencies on Postgres
How do I find dependencies between Postgres pipelines?
Audit cross-pipeline dependencies on Redshift
How do I find dependencies between Redshift pipelines?
Audit cross-pipeline dependencies on ClickHouse
How do I find dependencies between ClickHouse pipelines?
Audit cross-pipeline dependencies on DuckDB
How do I find dependencies between DuckDB pipelines?
Audit cross-pipeline dependencies on MotherDuck
How do I find dependencies between MotherDuck pipelines?
Audit cross-pipeline dependencies on MySQL
How do I find dependencies between MySQL pipelines?
Audit cross-pipeline dependencies on Athena
How do I find dependencies between Athena pipelines?
Audit cross-pipeline dependencies on Synapse
How do I find dependencies between Synapse pipelines?
Audit cross-pipeline dependencies on Microsoft Fabric
How do I find dependencies between Microsoft Fabric pipelines?
Impact analysis and debugging
8 use casesSee which columns feed a metric
How do I trace a metric back to its source columns?
Run impact analysis before a schema change
What breaks if I drop or rename this column?
Find unused columns in a model
Which columns in this table are never used downstream?
Document lineage automatically
Do I have to maintain lineage docs by hand?
Trace a dashboard back to raw sources
How do I connect a dashboard chart to the raw tables behind it?
Debug a wrong number using lineage
A metric looks wrong. How do I find where it went bad?
Show lineage in code review
Can reviewers see lineage impact in a pull request?
Map lineage across SQL and Python assets
Does lineage cover Python steps too, not just SQL?
Know what a change will break
Open source. Emergent column-level lineage across SQL and Python assets.