Airbyte ELT

When to Use

Load this skill when the user needs to:

• Design or configure Airbyte connections (source → destination)
• Choose and configure sync modes (Full Refresh Overwrite/Append, Incremental Append/Deduped)
• Deploy Airbyte via abctl, Kubernetes Helm chart, or Airbyte Cloud
• Build custom connectors with the no-code Connector Builder or Python CDK
• Understand raw vs. normalized tables and dbt-based normalization
• Manage connections programmatically via the Airbyte REST API or Terraform provider
• Handle schema evolution (propagation policies, breaking changes)
• Monitor sync health, review logs, and configure alerting
• Orchestrate Airbyte syncs from Apache Airflow

Architecture