Skip to main content
The basic install is covered on the integration overview: 
pip install "prefect[dbt]"
This installs prefect-dbt alongside dbt-core, but does not install any dbt database adapter. Without one, you will see an error like Could not find adapter type <type>! at runtime.

​
Install a dbt adapter

The modern PrefectDbtRunner path reads your existing profiles.yml, so all you need to add is the dbt adapter for your warehouse. Install it alongside prefect-dbt: 
pip install "prefect[dbt]" dbt-snowflake   # Snowflake
pip install "prefect[dbt]" dbt-bigquery    # BigQuery
pip install "prefect[dbt]" dbt-postgres    # Postgres
pip install "prefect[dbt]" dbt-duckdb      # DuckDB (local dev, CI)
pip install "prefect[dbt]" dbt-redshift    # Redshift
pip install "prefect[dbt]" dbt-databricks  # Databricks
See the dbt adapter list for every supported warehouse.

​
prefect-dbt extras (block-based config)

If you want to manage dbt profiles from Prefect rather than from profiles.yml — the legacy block-based configuration — prefect-dbt ships extras that bundle the matching dbt adapter together with Prefect block types:
ExtraInstalls
prefect-dbt[snowflake]dbt-snowflake + SnowflakeTargetConfigs block
prefect-dbt[bigquery]dbt-bigquery + BigQueryTargetConfigs block
prefect-dbt[postgres]dbt-postgres + PostgresTargetConfigs block
prefect-dbt[all_extras]All of the above
pip install "prefect-dbt[snowflake]"
pip install "prefect-dbt[bigquery]"
pip install "prefect-dbt[postgres]"
pip install -U "prefect-dbt[all_extras]"
The extras are only needed for the legacy DbtCliProfile / TargetConfigs block workflow. If you’re using PrefectDbtRunner with a normal profiles.yml, install the adapter directly as shown above.

​
Upgrading

Upgrade to the latest versions of prefect and prefect-dbt: 
pip install -U "prefect[dbt]"
Check compatibility notes in the prefect-dbt release notes before upgrading across minor versions.