I like using Airbyte as our main CDC tool to connect our production databases to the company’s main DWH. We also use it for batch files, Google Sheets, and APIs, which lets us trigger materializations with dbt. Overall, it helps us build end-to-end pipelines and keep a full picture of the process. I also appreciate the idea that we can quickly modify connectors when needed. The source code is easy to navigate and adapt to our needs, which makes it easier to share data between processes and to plug and play. It’s also helpful that, if something fails, we can send alerts to Slack via an incorporated webhook. Deploying it locally was straightforward. We still need to investigate how user authentication works, so not everyone is able to change connections and so on.

The AI assisted connector builder feature

I love that Airbyte makes it incredibly simple to pull data from multiple sources into our warehouse, allowing the unified analytics to run smoothly. Its capacity to handle most of the syncing tasks without requiring me to build custom pipelines is a massive relief. The product effectively removes the headache of manually building and maintaining connectors by ensuring that most sources work right out of the box. The scheduled syncs are particularly helpful as they keep our warehouse data updated without the need for manual intervention, thus enhancing the reliability and speed of our data pipeline. Setting up new connectors and monitoring syncs is also straightforward thanks to its clean, intuitive UI. Clear logs play a vital role in allowing me to quickly debug any sync issues, significantly cutting down on troubleshooting time so that I can focus more on utilizing the data. The initial setup of Airbyte was remarkably smooth, taking just a few minutes to spin up and adding the first connectors required minimal effort. When we transitioned from custom Python pipelines and some usage of Fivetran to Airbyte, we gained more control and reduced costs, which was a significant advantage. Overall, it's a solid, flexible, and cost-friendly solution.