lineage
Snowflake table/column lineage: impact analysis, root cause, data discovery, provenance, trust. Triggers: 'what depends on', 'what will break', 'blast radius', 'who uses', 'deprecate', 'before I change', 'affected users', 'downstream', 'cascade', 'root cause', 'trace upstream', 'where does this come from', 'feeds this table', 'sources of', 'column lineage', 'where does [column] come from', 'what uses [column]', 'trace [column]', 'is this trustworthy', 'which table should I use', 'recommend dataset', 'provenance', 'certify', 'verify source'. Also handles questions where users mention external systems (Power BI, Tableau, Sigma, Looker, dbt) — on accounts meeting either of two conditions (Horizon Catalog connectors (Private Preview) enabled, or GET_LINEAGE on a version supporting OpenLineage-sourced entities), lineage results from native-anchored queries automatically include external entities. For value-level data quality (wrong values, failing DMFs) use the data-quality skill first, then this skill to trace upstream. Always read reference/snowflake-apis.md before writing GET_LINEAGE SQL — it has the correct namespace, argument order, and output column names. When external entities appear in results, see reference/external-row-output.md.
Pinned to revision 05cff3d0ec12, so it is the text this page describes rather than whatever the author pushed since.
Files
- skills/lineage/SKILL.md
- skills/lineage/config/schema-patterns.yaml
- skills/lineage/reference/dynamic-trust-scoring.md
- skills/lineage/reference/external-row-output.md
- skills/lineage/reference/snowflake-apis.md
- skills/lineage/templates/change-detection-object-deps-fallback.sql
- skills/lineage/templates/change-detection.sql
- skills/lineage/templates/check-access-history.sql
- skills/lineage/templates/check-object-exists.sql
- skills/lineage/templates/column-change-detection.sql
- skills/lineage/templates/column-lineage-downstream.sql
- skills/lineage/templates/column-lineage-full.sql
- skills/lineage/templates/column-lineage-get-lineage.sql
- skills/lineage/templates/column-lineage-upstream.sql
- skills/lineage/templates/data-discovery.sql
- skills/lineage/templates/data-usage-stats.sql
- skills/lineage/templates/impact-analysis-fallback.sql
- skills/lineage/templates/impact-analysis-multi-level-object-deps-fallback.sql
- skills/lineage/templates/impact-analysis-multi-level.sql
- skills/lineage/templates/impact-analysis-object-deps-fallback.sql
- skills/lineage/templates/impact-analysis-users-object-deps-fallback.sql
- skills/lineage/templates/impact-analysis-users.sql
- skills/lineage/templates/impact-analysis.sql
- skills/lineage/templates/provenance-verification-object-deps-fallback.sql
- skills/lineage/templates/provenance-verification.sql
- skills/lineage/templates/root-cause-analysis-object-deps-fallback.sql
- skills/lineage/templates/root-cause-analysis.sql
- skills/lineage/templates/root-cause-column.sql
- skills/lineage/templates/root-cause-ddl-fallback.sql
- skills/lineage/workflows/column-lineage.md
- skills/lineage/workflows/data-discovery.md
- skills/lineage/workflows/impact-analysis.md
- skills/lineage/workflows/root-cause-analysis.md
Every link opens the file at its source, pinned to the revision this page describes.