How do I replace a partition when loading into Snowflake with ingestr?
Point ingestr at a Snowflake 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 Snowflake.
Command
ingestr ingestDefined in
CLI
Works with
Snowflake + ingestr
What you get
delete+insert strategyauto schemaone command
How it works in code
$ ingestr ingest \
--source-uri $SRC \
--dest-uri snowflake://... \
--incremental-strategy delete+insertRun ingestr ingest and ingestr applies the delete+insert strategy into Snowflake 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 scd2 strategy
How do I keep full history when loading into Snowflake with ingestr?
Move data with one command
Open source. Source URI in, destination URI out, incremental by default.