dbt plugins are all stuck to version 1.3 which means you're stuck below Python 3.11

[visch]

https://github.com/search?q=repo%3Ameltano%2Fhub%201.3.0&type=code

Updating locally to the below works!

  transformers:
  - name: dbt-postgres
    variant: dbt-labs
    pip_url: dbt-core~=1.8.0 dbt-postgres~=1.8.0

[edgarrmondragon]

Those are the transformers though, and I'd say they're deprecated in favor of utilities :)

Utilities have the version unpinned https://github.com/search?q=repo%3Ameltano%2Fhub+dbt-core+path%3A%2F%5E_data%5C%2Fmeltano%5C%2Futilities%5C%2F%2F&type=code.

[visch]

Ahh I ran meltano add transformer dbt-postgres and it did this automatically.

I needed to run meltano add utility dbt-postgres Something in the cli to warn would be nice, I was just jamming and didn't think about it until I hit production