Copy data from any source to any destination without any code

ingestr is a command-line app that allows you to ingest data from any source into any destination using simple command-line flags, no code necessary.

• ✨ copy data from your database into any destination
• ➕ incremental loading: append, merge or delete+insert
• 🐍 single-command installation

ingestr takes away the complexity of managing any backend or writing any code for ingesting data, simply run the command and watch the data land on its destination.

Installation

pip install ingestr

Quickstart

ingestr ingest \
    --source-uri 'postgresql://admin:admin@localhost:8837/web?sslmode=disable' \
    --source-table 'public.some_data' \
    --dest-uri 'bigquery://<your-project-name>?credentials_path=/path/to/service/account.json' \
    --dest-table 'ingestr.some_data'

That's it.

This command:

• gets the table public.some_data from the Postgres instance.
• uploads this data to your BigQuery warehouse under the schema ingestr and table some_data.

Documentation

You can see the full documentation here.

Community

Join our Slack community here.

Supported sources & destinations

Feel free to create an issue if you'd like to see support for another source or destination.

Acknowledgements

This project would not have been possible without the amazing work done by the SQLAlchemy and dlt teams. We relied on their work to connect to various sources and destinations, and built ingestr as a simple, opinionated wrapper around their work.