Daily batch refresh
IDpipelines.daily-batch
DescriptionOrchestrator runs the daily batch pipelines that refresh the warehouse.
Keydaily-batch
Tags
processing
storage
100%

Steps

Workflow steps
NumberSourceDestinationDescription
1OrchestratorDAG schedulerTrigger daily DAG
2DAG schedulerBatch pipelineRun tasks in order
3Batch pipelinedbt engineTransform raw to curated
4dbt engineData validatorRun tests
- if Tests pass
5Data validatorWarehouse loaderMaterialize tables
6Warehouse loaderData warehouseLoad gold layer
else Tests fail
7Data validatorOrchestratorBlock downstream
end
Open diagram editor (read-only in guest)