Join Slack
Powered by
Hi everyone, I've just configured Airbyte open sou...
# help-api-cli-orchestration
d
Dan Brookes
10/13/2023, 5:25 PM
Hi everyone, I've just configured Airbyte open source and I'm trying to understand how the dbt integration works. Airbyte Cloud seems to integrate with DBT Cloud, how does the open source version work?
u
user
10/13/2023, 5:25 PM
In the open-source version of Airbyte, the tool in charge of transformation behind the scenes is actually called [dbt](
https://blog.getdbt.com/what--exactly--is-dbt-/
) (Data Build Tool). Before generating the SQL files, Airbyte sets up a dbt Docker instance and automatically generates a dbt project for you. This is created as specified in the [dbt project documentation page](
https://docs.getdbt.com/docs/building-a-dbt-project/projects
) with the right credentials for the target destination. The dbt models are then run afterward, thanks to the [dbt CLI](
https://docs.getdbt.com/dbt-cli/cli-overview
). You can learn more about how to integrate SQL based transformations with Airbyte syncs using dbt in this [tutorial](
https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-dbt
). This tutorial is part of a series on transformations, which also includes [Transformations with SQL](
https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-sql
) and [Transformations with Airbyte](
https://docs.airbyte.com/operator-guides/transformation-and-normalization/transformations-with-airbyte
). Please note that custom DBT transformations are currently supported in the open-source version of Airbyte but not in the Cloud version, as mentioned in the [product roadmap](
https://app.harvestr.io/roadmap/view/pQU6gdCyc/launch-week-roadmap
).
Open in Slack
Previous
Next