Skip to main content

Use the dbt Cloud integration

Airbyte Cloud only
The following documentation only applies to Airbyte Cloud. You can try Airbyte Cloud for free with our 14-day trial.

By using the dbt Cloud integration, you can create and run dbt transformations during syncs in Airbyte Cloud. This allows you to transform raw data into a format that is suitable for analysis and reporting, including cleaning and enriching the data.

note

Normalizing data may cause an increase in your destination's compute cost. This cost will vary depending on the amount of data that is normalized and is not related to Airbyte credit usage.

Step 1: Generate a service token

Generate a service token for your dbt Cloud transformation.

note
  • To use the dbt Cloud integration, you must use a paid version of dbt Cloud.
  • The service token must have Member, Job Admin, or Account Admin permissions.

Step 2: Set up the dbt Cloud integration in Airbyte Cloud

To set up the dbt Cloud integration in Airbyte Cloud:

  1. In the Airbyte UI, click Settings.

  2. Click dbt Cloud integration.

  3. Paste the service token from Step 1 and click Save changes.

  4. Click Connections and select the connection you want to add a dbt transformation to.

  5. Go to the Transformation tab and click + Add transformation.

  6. Select the transformation from the dropdown and click Save changes. The transformation will run during the subsequent syncs until you remove it.

note

You can have multiple transformations per connection.

  1. To remove a transformation, click X on the transformation and click Save changes.