Mode 1 · INGEST_MODE=local
fast local loop — try this first
Mode 2 · INGEST_MODE=aca
prod shape — after image is in ACR
ASTRO WORKER
1 · ingest (local Python)
2 · dbt_build (subprocess)
3 · publish_to_backend
all three tasks in one container
ASTRO
1 · ingest
(triggers job)
ACA JOB
pipeline.py
runs ingest
then
ASTRO WORKER
2 · dbt_build (subprocess)
3 · publish_to_backend
same worker as Mode 1
BOTH MODES — tasks 2 and 3
Databricks SQL warehouse
dbt executes SQL here
Postgres analytics_dev
publish writes here
Astro / worker
ACA job
Prod schedule always uses Mode 2 (ACA).