dbt Core v1.3 adds support for Python models. Note that only specific data platforms support dbt-py models.
We encourage you to:
- Read the original discussion that proposed this feature.
- Contribute to best practices for developing Python models in dbt.
- Weigh in on next steps for Python models, beyond v1.3.
- Join the #beta-feedback-python-models channel in the dbt Community Slack.
dbt Python ("dbt-py") models will help you solve use cases that can't be solved with SQL. You can perform analyses using tools available in the open-source Python ecosystem, including state-of-the-art packages for data science and statistics. Before, you would have needed separate infrastructure and orchestration to run Python transformations in production. Python transformations defined in dbt are models in your project with all the same capabilities around testing, documentation, and lineage.