Lineage Skill

/armor:lineage

You: What depends on the customers table?

Claude: Found 7 downstream tables that depend on customers:

Direct consumers (depth 1):
- gold.customer_metrics
- gold.order_summary
- reporting.customer_dashboard

Indirect consumers (depth 2):
- ml.churn_features
- ml.ltv_predictions
- analytics.weekly_cohorts
- external.bi_tool_view

Any changes to customers will affect these tables.

You: Where does the orders_mart table get its data?

Claude: orders_mart has 4 upstream sources:

Direct sources:
- staging.orders_raw
- staging.customers
- staging.products

Root sources:
- raw.events

Data flow:
raw.events -> staging.orders_raw -> gold.orders_mart

You: If I change the users table schema, what's affected?

Claude: Impact analysis for users:

Directly affected (12 tables):
- gold.user_metrics
- gold.user_activity
- reporting.user_dashboard
- ml.user_features
...

Indirectly affected (5 tables):
- analytics.monthly_actives
- reporting.exec_summary
...

Total: 17 tables may need updates.

Recommendation: Test changes in staging before production.