Hi everyone, I've just configured Airbyte open sou...
# help-api-cli-orchestration
d
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
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).