scope jaffle_ods/default
compared with snapshot 1 in .ods/state.db
plan 4 to build and test, 10 to reuse
saved ~2.5s of build time (estimate, serial: 10 of 14 nodes reused)
dbt target_dir target (default)
target dev (jaffle_ods, duckdb, fake-host, jaffle_ods)
ran dbt build --select fqn:jaffle_ods.marts.customer_segments,resource_type:model
fqn:jaffle_ods.marts.customers,resource_type:model fqn:jaffle_ods.marts.customers_snapshot_view,resource_type:model
fqn:jaffle_ods.marts.segment_summary,resource_type:model --target-path /tmp/ods-demo/jaffle_shop/target --write-json
--partial-parse-file-diff --indirect-selection eager --log-format json --log-level debug
outcome failed
totals 21ms · 2 built · 1 failed · 1 skipped
rows at least 100 (2 nodes didn't report rows)
stats reported as it ran
journal .ods/state.db.runs/cb06ed7d-ae14-403b-8a67-416bbc0c3d50.jsonl
recorded snapshot 2: 2 nodes advanced
┏━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┳━━━━━━━┳━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ node ┃ result ┃ took ┃ rows ┃ why it ran ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━╇━━━━━━━╇━━━━━━╇━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┩
│ customers │ success │ 250ms │ 100 │ code changed since run │
│ │ │ │ │ f6fe28b2-58b2-4742-b0e2-a5e36e30d70d: │
│ │ │ │ │ sql │
│ customer_segments │ failed: KeyError: [value removed] │ 250ms │ — │ upstream code changed: customers will │
│ │ │ │ │ be rebuilt │
│ customers_snapshot_view │ success │ 250ms │ — │ upstream code changed: customers will │
│ │ │ │ │ be rebuilt │
│ segment_summary │ skipped │ — │ — │ upstream code changed: │
│ │ │ │ │ customer_segments will be rebuilt │
└─────────────────────────┴───────────────────────────────────┴───────┴──────┴─────────────────────────────────────────┘
Why it failed
error[python-exception]: customer_segments failed: The Python model raised KeyError
--> models/marts/customer_segments.py
note: python model · python exception (confidence: known pattern)
note: why ODS thinks so: It failed after 250ms, during execution (compile succeeded). [run stats]
note: why ODS thinks so: Its code didn't change since its last successful build, in run f6fe28b2. [fingerprints]
note: compiled: target/compiled/jaffle_ods/models/marts/customer_segments.py
note: blocks 1 downstream node (segment_summary was skipped). Its last good build is kept.
note: dbt said: KeyError: [value removed] (Literal values and SQL removed.)
note: full text: dbt's log file (logs/dbt.log in the project, unless --log-path)
help: Read the traceback in the full log: it shows where in the model's code the exception was raised.
help: Then retry what failed: $ ods state retry --failed
info: 2 nodes kept their last successful state and will be built next run
error[ODS-E0404]: the run didn't fully succeed (2 nodes failed, were skipped or failed their tests; 0 checks failed)
help: nodes that built and passed their tests were recorded; the others keep their last successful state and are built
(and tested) next run
❯