Hello everyone, I am evaluating meltano and get stuck when trying to install _*meltano dbt-postgres utility*_: The error message is:

[...]

Installing build dependencies: started

Installing build dependencies: finished with status 'done'

Getting requirements to build wheel: started

Getting requirements to build wheel: finished with status 'done'

Preparing metadata (pyproject.toml): started

error: subprocess-exited-with-error

à Preparing metadata (pyproject.toml) did not run successfully.

â exit code: 1

â°â> See above for output.

note: This error originates from a subprocess, and is likely not a problem with pip.

Preparing metadata (pyproject.toml): finished with status 'error'

error: metadata-generation-failed

à Encountered error while generating package metadata.

â°â> See above for output.

Athough the install failed, I can successfully run: meltano config dbt-postgres set --interactive But then: meltano invoke dbt-postgres:initialize fails with the error message:

Environment 'dev' is active

`2024-02-26T160712.821906Z [warning ]

kind: password

is deprecated for setting definitions in favour of

sensitive: true

, and is currently in use by the following settings of utility 'dbt-postgres': 'password'. Please open an issue or pull request to update the plugin definition on Meltano Hub at https://github.com/meltano/hub/blob/main/_data/meltano/utilities/dbt-postgres/dbt-labs.yml.`

Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to

join our friendly Slack community.

`Executable 'dbt_invoker' could not be found. Utility 'dbt-postgres' may not have been installed yet using

meltano install utility dbt-postgres

, or the executable name may be incorrect.` Thanks in advance for any help !

Hey @Klein Etienne! Can you share a few details with me to help figure it out? 1. Meltano version 2. Python version Meltano is installed on 3. Operating System

Hello Edgar, In the meantime I found the issue: Python version ! I am working in a dev container with WSL, and by default I used the image with one of the latest version of Python (3.12.2 if I am right) to build my evaluation environment. After some reading, I found that some extensions are not compatible with the latest version of Python. So I downgrade my image to use Python 3.8 and now it works. So, FYI, I am using now: • Debian GNU/Linux 11 (bullseye) • meltano, version 3.3.1 • Python 3.8.18 BTW after the downgrade I had another issue: running the command: meltano invoke dbt-postgres:initialize initialized my dbt_project.yml with a "target" path pointing to ../.meltano/transformers/dbt/target. And when running: meltano invoke dbt-postgres:debug I had a message from dbt telling me it cannot clean outside its project (something like that). Changing the path to simply "target" fixed the issue. Thanks again for your very quick answer !

Yeah, that latter

dbt clean

issue is known unfortunately: https://github.com/meltano/meltano/issues/8391