How do I replace a partition when loading into MotherDuck with ingestr?
Point ingestr at a MotherDuck destination URI and pass the delete+insert strategy to replace a partition. ingestr handles the schema and the incremental logic, so there is no custom merge code for MotherDuck.
Command
ingestr ingestDefined in
CLI
Works with
MotherDuck + ingestr
What you get
delete+insert strategyauto schemaone command
How it works in code
$ ingestr ingest \
--source-uri $SRC \
--dest-uri motherduck://... \
--incremental-strategy delete+insertRun ingestr ingest and ingestr applies the delete+insert strategy into MotherDuck on every run.
Related use cases
Incremental loads by warehouse
Load into Snowflake with the merge strategy
How do I upsert changed rows when loading into Snowflake with ingestr?
Incremental loads by warehouseLoad into Snowflake with the append strategy
How do I append new rows when loading into Snowflake with ingestr?
Incremental loads by warehouseLoad into Snowflake with the delete+insert strategy
How do I replace a partition when loading into Snowflake with ingestr?
Move data with one command
Open source. Source URI in, destination URI out, incremental by default.