Installation

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:

pip install "prefect-dbt[snowflake]"
pip install "prefect-dbt[bigquery]"
pip install "prefect-dbt[postgres]"
pip install -U "prefect-dbt[all_extras]"

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.