Use Cases · For data engineers
Data ingestion with ingestr
Copy data from any source into your warehouse with a single command. Incremental strategies, auto schema, open source, and pipeline-native.
Incremental loads by warehouse
40 use casesLoad into Snowflake with the merge strategy
How do I upsert changed rows when loading into Snowflake with ingestr?
Load into Snowflake with the append strategy
How do I append new rows when loading into Snowflake with ingestr?
Load into Snowflake with the delete+insert strategy
How do I replace a partition when loading into Snowflake with ingestr?
Load into Snowflake with the scd2 strategy
How do I keep full history when loading into Snowflake with ingestr?
Load into BigQuery with the merge strategy
How do I upsert changed rows when loading into BigQuery with ingestr?
Load into BigQuery with the append strategy
How do I append new rows when loading into BigQuery with ingestr?
Load into BigQuery with the delete+insert strategy
How do I replace a partition when loading into BigQuery with ingestr?
Load into BigQuery with the scd2 strategy
How do I keep full history when loading into BigQuery with ingestr?
Load into Postgres with the merge strategy
How do I upsert changed rows when loading into Postgres with ingestr?
Load into Postgres with the append strategy
How do I append new rows when loading into Postgres with ingestr?
Load into Postgres with the delete+insert strategy
How do I replace a partition when loading into Postgres with ingestr?
Load into Postgres with the scd2 strategy
How do I keep full history when loading into Postgres with ingestr?
Load into Databricks with the merge strategy
How do I upsert changed rows when loading into Databricks with ingestr?
Load into Databricks with the append strategy
How do I append new rows when loading into Databricks with ingestr?
Load into Databricks with the delete+insert strategy
How do I replace a partition when loading into Databricks with ingestr?
Load into Databricks with the scd2 strategy
How do I keep full history when loading into Databricks with ingestr?
Load into Redshift with the merge strategy
How do I upsert changed rows when loading into Redshift with ingestr?
Load into Redshift with the append strategy
How do I append new rows when loading into Redshift with ingestr?
Load into Redshift with the delete+insert strategy
How do I replace a partition when loading into Redshift with ingestr?
Load into Redshift with the scd2 strategy
How do I keep full history when loading into Redshift with ingestr?
Load into DuckDB with the merge strategy
How do I upsert changed rows when loading into DuckDB with ingestr?
Load into DuckDB with the append strategy
How do I append new rows when loading into DuckDB with ingestr?
Load into DuckDB with the delete+insert strategy
How do I replace a partition when loading into DuckDB with ingestr?
Load into DuckDB with the scd2 strategy
How do I keep full history when loading into DuckDB with ingestr?
Load into MotherDuck with the merge strategy
How do I upsert changed rows when loading into MotherDuck with ingestr?
Load into MotherDuck with the append strategy
How do I append new rows when loading into MotherDuck with ingestr?
Load into MotherDuck with the delete+insert strategy
How do I replace a partition when loading into MotherDuck with ingestr?
Load into MotherDuck with the scd2 strategy
How do I keep full history when loading into MotherDuck with ingestr?
Load into ClickHouse with the merge strategy
How do I upsert changed rows when loading into ClickHouse with ingestr?
Load into ClickHouse with the append strategy
How do I append new rows when loading into ClickHouse with ingestr?
Load into ClickHouse with the delete+insert strategy
How do I replace a partition when loading into ClickHouse with ingestr?
Load into ClickHouse with the scd2 strategy
How do I keep full history when loading into ClickHouse with ingestr?
Load into MySQL with the merge strategy
How do I upsert changed rows when loading into MySQL with ingestr?
Load into MySQL with the append strategy
How do I append new rows when loading into MySQL with ingestr?
Load into MySQL with the delete+insert strategy
How do I replace a partition when loading into MySQL with ingestr?
Load into MySQL with the scd2 strategy
How do I keep full history when loading into MySQL with ingestr?
Load into Athena with the merge strategy
How do I upsert changed rows when loading into Athena with ingestr?
Load into Athena with the append strategy
How do I append new rows when loading into Athena with ingestr?
Load into Athena with the delete+insert strategy
How do I replace a partition when loading into Athena with ingestr?
Load into Athena with the scd2 strategy
How do I keep full history when loading into Athena with ingestr?
Load into your warehouse
12 use casesLoad any source into Snowflake with one command
How do I get data from a SaaS tool or database into Snowflake without building a connector?
Load any source into BigQuery with one command
How do I get data from a SaaS tool or database into BigQuery without building a connector?
Load any source into Postgres with one command
How do I get data from a SaaS tool or database into Postgres without building a connector?
Load any source into Databricks with one command
How do I get data from a SaaS tool or database into Databricks without building a connector?
Load any source into Redshift with one command
How do I get data from a SaaS tool or database into Redshift without building a connector?
Load any source into DuckDB with one command
How do I get data from a SaaS tool or database into DuckDB without building a connector?
Load any source into MotherDuck with one command
How do I get data from a SaaS tool or database into MotherDuck without building a connector?
Load any source into ClickHouse with one command
How do I get data from a SaaS tool or database into ClickHouse without building a connector?
Load any source into MySQL with one command
How do I get data from a SaaS tool or database into MySQL without building a connector?
Load any source into Athena with one command
How do I get data from a SaaS tool or database into Athena without building a connector?
Load any source into Synapse with one command
How do I get data from a SaaS tool or database into Synapse without building a connector?
Load any source into Microsoft Fabric with one command
How do I get data from a SaaS tool or database into Microsoft Fabric without building a connector?
ingestr recipes and comparisons
6 use casesUse ingestr as an open-source alternative to Fivetran
Is there an open-source, command-line alternative to Fivetran?
Use ingestr as an alternative to Airbyte
Can I replace an Airbyte deployment with something simpler?
Replace a Sling script with ingestr
How does ingestr compare to Sling for moving data?
Move data between two databases
How do I copy a table from one database to another quickly?
Ingest a SaaS API without writing a connector
How do I pull data from a SaaS tool without building an integration?
Schedule ingestion inside a Bruin pipeline
How do I run ingestion as a step in my pipeline?
Incremental loading strategies
5 use casesLoad data with the replace strategy in ingestr
How do I fully reload a table on each run with ingestr?
Load data with the append strategy in ingestr
How do I append only new rows with ingestr?
Load data with the merge strategy in ingestr
How do I upsert changed rows with ingestr?
Load data with the delete+insert strategy in ingestr
How do I replace a date partition with ingestr?
Load data with the scd2 strategy in ingestr
How do I keep full history with ingestr?
Move data with one command
Open source. Source URI in, destination URI out, incremental by default.