Airbyte
FreemiumThe leading open-source data integration platform.
Scores
About
Airbyte is an open-source data integration platform built for ELT (Extract, Load, Transform) pipelines. It provides 600+ pre-built connectors covering databases, SaaS APIs, files, and streaming sources, and delivers data to warehouses, data lakes, and lakehouses.
The self-hosted Core edition is free and runs on any infrastructure via Docker or Kubernetes. Airbyte Cloud offers a fully managed alternative with usage-based pricing. For teams wanting the open-source flexibility with enterprise controls (SSO, RBAC, audit logs), Airbyte Enterprise provides a self-managed commercial tier.
Airbyte's connector development kit (CDK) makes it possible to build custom connectors in Python, and the connector catalog is community-maintained — making it one of the fastest-growing integration ecosystems in the modern data stack. It is commonly paired with dbt for transformation and Airflow or Dagster for orchestration.
Key Features
- 600+ pre-built source and destination connectors
- Self-hosted (Docker/Kubernetes) or fully managed cloud
- Python Connector Development Kit for custom connectors
- Change Data Capture (CDC) for database sources
- Full refresh and incremental sync modes
- Schema evolution handling and normalization
- Native dbt integration for in-warehouse transformation
Pros
- Massive connector library covering long-tail SaaS sources Fivetran doesn't support
- Self-hosted Core is completely free with no connector or row limits
- Active open-source community with fast connector contributions
- Simple UI for non-engineers to set up and monitor syncs
- CDC support for low-latency database replication
Cons
- Cloud pricing (credit-based) can be unpredictable at scale
- Self-hosting requires meaningful infrastructure — Kubernetes recommended for production
- Core license is ELv2 (source-available), not fully OSI-approved open-source
- Enterprise features (SSO, RBAC) locked behind paid tiers
- Transformation capabilities are basic — dbt is needed for anything beyond normalization
Pricing
Freemium- · All 600+ connectors
- · Self-managed deployment (Docker or Kubernetes)
- · No row or connector limits
- · Community support only
- · Fully managed cloud hosting
- · Usage-based credit pricing ($2.50/credit overage)
- · API sources: $15 per million rows; DB sources: $10 per GB
- · Annual billing, minimum ~$25,000/year
- · Accelerated support
- · Bulk-credit discounts
- · SSO and SCIM provisioning
- · Fine-grained RBAC and audit logs
- · Multiple workspaces
- · Dedicated support engineer
Possible Stacks
Airbyte + ClickHouse + Grafana
ProjectAirbyte syncs data from any source into ClickHouse, a columnar OLAP database that handles billions of rows at millisecond query speed. Grafana connects to ClickHouse for real-time dashboards and alerting. Python handles any custom ingestion scripts.
Airbyte + dbt + Snowflake + Tableau
ProjectAirbyte loads raw data from 300+ sources into Snowflake; dbt transforms it into documented, tested models; Tableau connects directly to Snowflake for governed self-service analytics and executive dashboards.
Modern ELT Stack
ProjectThe standard open-source ELT pattern: Airbyte extracts and loads data from 300+ sources into Snowflake; dbt transforms raw tables into clean, tested models; Airflow schedules the whole pipeline as a DAG. Docker makes the stack portable across environments.
Related Tools
Works well with (5)
Integrates with (7)
Learning Resources
No resources yet — check back soon.
