Meltano, dbt have package dependency conflicts

[ravichandrasekaran]

Running into dependency conflicts with the most recent versions of dbt, meltano. My requirements.txt file attached. Do you know which versions to pin these to? (With the dependency issues, might help to use a requirements.txt file for the project?)

requirements.txt

$ pip install meltano
...
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
dbt-core 1.0.2 requires click<9,>=8, but you have click 7.1.2 which is incompatible.

$ pip install dbt-postgres
...
ERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.
meltano 1.96.0 requires click<8.0,>=7.0, but you have click 8.0.4 which is incompatible.
flask 1.1.4 requires click<8.0,>=5.1, but you have click 8.0.4 which is incompatible.

[ravichandrasekaran]

Note: This is on Python 3.7 and 3.8 - might not be an issue on more recent version?

[andrewcstewart]

Not surprised. In practice though it probably makes more sense to install dbt within meltano rather than side by side.

[wheresalice]

I also see this issue in Python 3.9

I can confirm that installing dbt within meltano as a transform works better, as long as you accept the versions that it gives you and don't try upgrading anything with pip