Installation

Install prefect-dbt with a dbt adapter for any warehouse

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:

Extra	Installs
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.