prefect-dbt
Prefect integrations for working with dbt
Decision gist · record as of 2026-08-14
Yes, if you use both Prefect and dbt. The integration is actively maintained, has low install friction, carries no license restrictions, and solves a clear orchestration gap. Install it only if you need to run dbt within Prefect workflows; standalone dbt projects do not require it.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.10 or later; dbt-core must be installed separately as a runtime dependency.
- Low install friction with a pure Python wheel.
- Actively maintained with recent releases; the repository is active and well-starred, indicating ongoing support and community engagement.
License · maintenance · safety
Apache License 2.0 (permissive) — Apache License 2.0 is permissive, allowing commercial use, modification, and distribution with minimal restrictions—suitable for most production environments.
last release 2026-06-05 (70 days) · last repo commit 2026-08-14 · 23,623 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 758,869 downloads/mo, #5,131 on PyPI
Alternatives
Verify before relying
pip install prefect-dbt
from prefect_dbt.cli.commands import dbt_shell_command
result = dbt_shell_command(command="dbt run")- Whether prefect_shell is a required or optional runtime dependency for typical workflows
- What sgqlc is used for within the integration and whether it is required for all use cases
What it is and what it does
prefect-dbt is a Prefect integration that bridges dbt (data build tool) and Prefect's workflow orchestration platform. It provides tasks and utilities to execute dbt commands—such as dbt run, dbt test, and dbt build—as part of larger Prefect data pipelines. This lets you orchestrate dbt model runs alongside other data tasks, apply Prefect's scheduling, retry logic, and monitoring to dbt workflows, and integrate dbt outputs into downstream pipeline steps.
The package depends on prefect, dbt-core, prefect_shell, and sgqlc. It supports Python 3.10 through 3.13 and is actively maintained. Installation is straightforward with low friction, and the permissive Apache 2.0 license poses no restrictions for most use cases.
Use it for
- Schedule and monitor dbt model runs as part of a larger Prefect data orchestration pipeline
- Chain dbt transformations with upstream data ingestion and downstream analytics tasks in a single workflow
- Apply Prefect's retry policies, error handling, and alerting to dbt command execution
- Parameterize dbt runs within Prefect flows to test different model configurations or data subsets
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes, if you use both Prefect and dbt.
The integration is actively maintained, has low install friction, carries no license restrictions, and solves a clear orchestration gap. Install it only if you need to run dbt within Prefect workflows; standalone dbt projects do not require it.
Install
prefect-dbt on PyPI
Before you install
Low install friction with a pure Python wheel. Actively maintained with recent releases; the repository is active and well-starred, indicating ongoing support and community engagement.
Requires Python 3.10 or later; dbt-core must be installed separately as a runtime dependency.
License in practice
Apache License 2.0 is permissive, allowing commercial use, modification, and distribution with minimal restrictions—suitable for most production environments.
Quickstart
pip install prefect-dbt
from prefect_dbt.cli.commands import dbt_shell_command
result = dbt_shell_command(command="dbt run")Verify before relying
- Whether prefect_shell is a required or optional runtime dependency for typical workflows
- What sgqlc is used for within the integration and whether it is required for all use cases
Package facts
| License | Apache License 2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 4 packagesprefectdbt-coreprefect_shellsgqlc |
| Maintenance | Actively maintained 70 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 758,869 / month, #5,131 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Intended Audience :: DevelopersIntended Audience :: System AdministratorsLicense :: OSI Approved :: Apache Software LicenseNatural Language :: EnglishProgramming Language :: Python :: 3 :: OnlyProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Topic :: Software Development :: Libraries |
Evidence: prefect_dbt-0.7.25-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “dbt workflow orchestration”
- prefect-dbtPrefect integration that orchestrates dbt workflows, allowing you to…
- dagster-dbtIntegrates dbt data transformation workflows into Dagster's…
- apache-airflow-providers-dbt-cloudIntegrates dbt Cloud with Apache Airflow, enabling orchestration of…
Give your agent the search over MCP, or paste the wish link into any chat.
More Libraries packages
urllib3 is an HTTP client library that provides thread-safe connection pooling, SSL/TLS verification, multipart file uploads, request retries, compression support, and proxy handling for Python applications.
Requests is a Python HTTP library that simplifies sending HTTP/1.1 requests with automatic handling of headers, authentication, cookies, and response parsing.
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
Provides parsing, arithmetic, and recurrence rule computation for dates and times, with timezone support and iCalendar RFC compliance.
Install it if you need to parse flexible date strings, compute relative dates, handle timezones, or work with recurrence rules—it's the de facto choice for these tasks.
Six provides utility functions to write Python code that runs on both Python 2.7 and Python 3.3+, smoothing over language differences between the two versions.
pytest is a testing framework that lets you write test functions using plain assert statements and automatically discovers and runs them, with detailed failure reporting.
See also prefect · prefect-shell · prefect-dask · prefect-snowflake · prefect-docker · prefect-sqlalchemy · prefect-email · prefect-cloud · prefect-ray · prefect-azure