Skip to main content

Use the dbt Cloud integration

AvailableCloud Not availableSelf-Managed Community (OSS)Not availableSelf-Managed Enterprise

By using the dbt Cloud integration, you can create and run dbt transformations immediately following 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

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

Prerequisites​

  • 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.
  • Airbyte currently only supports integration with dbt Cloud accounts that have an access URL beginning with https://cloud.getdbt.com/. Custom access URLs are not supported at this time.

Step 1: Generate a service token​

Generate a service token to enable authentication with dbt Cloud.

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

  1. Click Settings and then Integrations. Enter your service token and click Save changes.

  2. Click Connections and select the connection you want to add a dbt transformation to. Go to the Transformation tab and click + Add transformation.

  3. Select the transformation from the dropdown and click Save changes. The transformation will run after the subsequent syncs until you remove it. You can repeat these steps to add additional transformations for a connection.

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

Was this page helpful?