Tracing Upstream Lineage

When you're staring at a table wondering where the hell the data actually comes from, this walks you through the investigation. It shows you how to find the DAG that populates your table, trace back through the SQL to spot upstream sources, and recursively build the full chain from external systems like Salesforce or S3 all the way to your target. The column-level tracing is genuinely useful for tracking down specific field origins through transformations. If you're on Astro you get a visual lineage tab that does some of this automatically, but on OSS Airflow you're reading DAG source code and task definitions manually. The lineage report format with diagrams and data quality implications is solid for documenting what you find.

Install to Claude Code

npx -y skills add astronomer/agents --skill tracing-upstream-lineage --agent claude-code