ingestr recipes/Load into your warehouseData Engineer

How do I get data from a SaaS tool or database into DuckDB without building a connector?

ingestr copies data from any supported source into DuckDB with a single command. You give it a source URI and a DuckDB destination URI, and it handles schema and incremental loading.

Command

ingestr ingest

Defined in

CLI

Works with

DuckDB + ingestr

What you get

One-command loadauto schemaincremental

How it works in code

$ ingestr ingest \
  --source-uri postgres://... \
  --dest-uri duckdb://...

Run ingestr ingest and the data lands in DuckDB, incrementally on every run.

Move data with one command

Open source. Source URI in, destination URI out, incremental by default.

Sign up to our newsletter

Practical updates on open-source data pipelines, AI analysts, governance, and what we are shipping at Bruin.