1. acme-prod
  2. Pipelines
  3. nightly_orders_elt
  4. run 2026-10-11

Pipeline run

nightly_orders_elt

Scheduled run for 2026-10-10, started 01:00 IST, failed after 26m 06s at quality_checks.

1,284 orders reference customers that do not exist yet

The relationships check on fct_orders.customer_id failed. dim_customers was last refreshed at 23:10, before the CRM export landed at 00:40. load_warehouse and 2 downstream tasks did not run, so dashboards still show yesterday.

Last 14 runs

successfailedupstream failedrunningskipped
Duration
extract_orders
extract_payments
stage_raw
dbt_staging
dbt_marts
quality_checks
load_warehouse
refresh_dashboards
notify_finance
Runscheduled__2026-10-10T19:30:00Duration26m 06s1 failed
  • extract
  • spark
  • dbt
  • checks
  • extract_ordersok
  • extract_paymentsok
  • stage_rawok
  • dbt_stagingok
  • dbt_martsok
  • quality_checksexit 1

quality_checks, attempt 1 of 1

Raw log
  1. INFOdbt testrunning 6 checks on analytics.fct_orders (412,688 rows)
  2. INFOdbt testpass not_null(order_id)
  3. INFOdbt testpass unique(order_id)
  4. INFOdbt testpass accepted_values(currency, [INR, USD, EUR])
  5. ERRORdbt testfail relationships(customer_id -> dim_customers.id): 1,284 orphan rows
  6. WARNdbt testwarn freshness(_loaded_at): 26m behind source, threshold 30m
  7. ERRORdbt testquality_checks failed: 1 of 6 checks, blocking load_warehouse

Outputs

written by this run
  • analytics.stg_orders412,688 rows · 1.9 GBFresh
  • analytics.fct_orders412,688 rows · 2.4 GBUnverified
  • warehouse.orders_dailyNot loaded tonightStale 25h
Trigger
Schedule, 0 1 * * *
Worker pool
pool-b · 4 workers
Commit
e19a07f