Paths Subjects Questions Quizzes Pricing Search
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.

  1. Diagnose the root cause connecting the missing lineage edge and the CI gap — they are the same bug. Explain precisely why.
  2. Fix the model.
  3. 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

← Back to dbt & Analytics Engineering practice

We use cookies for product analytics to improve OmniAtlas. See our Privacy Policy.