I’m trying to use prefect-dbt on MacOS (Ventura 13.2.1, Python 3.11.2) with no success. After installing prefect-dbt with pip, my dbt stops working and throws an error:
17:11:23 Error importing adapter: No module named 'dbt.adapters.snowflake' 17:11:23 Encountered an error while reading profiles: ERROR: Runtime Error Credentials in profile "dbt_dwh_models", target "default" invalid: Runtime Error Could not find adapter type snowflake!Defined profiles: - dbt_dwh_models For more information on configuring profiles, please consult the dbt docs: https://docs.getdbt.com/docs/configure-your-profile 17:11:23 Encountered an error: Runtime Error Could not run dbt
Before installing prefect-dbt, dbt used to run fine. I noticed that installing prefect-dbt changes my dbt executable.
Perhaps relevant: on my Mac, I need to use Homebrew to successfully install dbt. Installing with pip doesn’t work.
Did anyone successfully ran Prefect + dbt on a Mac?