An open-source EL(T) tool that replicates data from third-party apps, databases, warehouses, and external APIs to cloud data warehouses, lakes, and databases.
Airbyte caters to the ELT needs of modern data teams.
ELT or Extract, Load, Transform refers to extracting data from production databases and external apps, loading the data into a cloud data warehouse, and post that, transforming the data to derive insights and drive action.
Airbyte supports a range of pre-built connectors and offers a Connector Development Kit, allowing one to build custom source connectors. Additionally, it integrates with dbt for post-load transformations as well as with Airflow for pipeline orchestration.