How do I backfill historical partitions on MotherDuck?
Run the pipeline with a start and end date and Bruin executes each partition against MotherDuck, so backfills are one command instead of a script.
Command
bruin runDefined in
SQL + Python + YAML
Works with
MotherDuck + Bruin CLI
What you get
Partitioned backfillsone commandwarehouse-native
How it works in code
$ bruin run --start-date 2026-01-01 ./pipeline # motherduckRun bruin run and Bruin runs the graph against MotherDuck in dependency order.
Related use cases
Orchestration by warehouse
Orchestrate a pipeline on Snowflake without Airflow
How do I orchestrate a Snowflake pipeline without a separate scheduler?
Orchestration by warehouseBackfill a Snowflake pipeline for a date range
How do I backfill historical partitions on Snowflake?
Orchestration by warehouseRun incremental models on Snowflake in dependency order
How do I run only the affected Snowflake models after a change?
SQL and Python, one pipeline
Open source. Define assets, declare dependencies, run the graph with bruin run.