Intermediate
Open
Pro
A Model Is Missing From the Lineage Graph and Running Out of Order
A teammate opens dbt docs serve to trace how fct_customer_ltv is
built and notices it doesn't show any connection to
int_orders_with_payments in the lineage graph, even though
fct_customer_ltv.sql clearly reads from it:
-- models/marts/fct_customer_ltv.sql
{{ config(materialized='table') }}
select
customer_id,
sum(total_amount) as lifetime_value
from analytics_prod.intermediate.int_orders_with_payments
group by 1
Separately, a CI run on a PR that only changed
int_orders_with_payments.sql did not rebuild or retest
fct_customer_ltv at all, even though the PR's intent was to fix a
bug in int_orders_with_payments that clearly affects LTV
calculations downstream.
- Diagnose the root cause connecting the missing lineage edge and the CI gap — they are the same bug. Explain precisely why.
- Fix the model.
- Beyond fixing this one model, what would you check across the rest of the project to make sure this isn't a systemic issue, and how would you check it without manually reading every model file?
Share this question