We built a dbt adapter that helps you run local Python code with your dbt project with any other data warehouse. You can see it here: https://github.com/fal-ai/fal/tree/main/adapter

It is very simple to use, but also very feature rich. For example, you can run each dbt model in an isolated Python environment and avoid dependency hell. We use isolate, an open source library we built to do that: https://github.com/fal-ai/isolate