or go to full-text search page →

Search

Search IconIcon to open search

Data Integration CLI tools

Last updatedUpdated: by Simon Späti · CreatedCreated: · 1 min read · growing Note status Growing. Worked on quite a bit, still rough. Expect bullets, gaps and views that update. Estimated from edit history · 5 sessions over 2 years · 144 words · How my notes grow Recent changes 4 months ago +10 / −2 words 4 months ago +118 / −3 words 8 months ago +0 / −3 words 3 years ago +2 / −8 words 3 years ago published · 14 words

Data Integration that supports CLI use cases.

# Tools

  • dlt: Python-based data integration library designed from the ground up to improve upon Airbyte/Meltano. Perfect fit as a library rather than platform, with well-thought-through architecture and comprehensive connector ecosystem
  • Sling: Similar to dlt, recommended by Dagster team. Works well integrated with Dagster orchestrator, supports incremental loading with custom SQL
  • Steampipe: SQL-based, very lean tool but lacks advanced features like incremental loading, full load functionality, and UI. Lower customization for non-existing connectors compared to dlt
  • ConnectorX: Fast connector for data transfer
  • ingestr: Simple one-to-one copy tool. For more complex scenarios, dlt is recommended as better alternative
  • SDF (now dbt Fusion)
  • Meltano (bought, see Data Engineering Acquisitions)

# Further Reads


Origin: Data Integration Tools- Choose the Right One