Hi I m setting up a test instance for meltano cloud I tried Meltano #troubleshooting

Hi! I’m setting up a test instance for meltano cl...

marieke

08/08/2023, 6:50 PM

Hi! I’m setting up a test instance for meltano cloud. I tried to add the redshift loader with

meltano add loader target-redshift

but am getting errors installing it. Any ideas?

Copy code

ERROR: Failed building wheel for psycopg2-binary
ERROR: Could not build wheels for psycopg2-binary, which is required to install pyproject.toml-based projects

marieke

08/08/2023, 6:51 PM

I’ve had issues with this package in the past (I’m 96% sure it’s also used/has been used with dbt).

edgar_ramirez_mondragon

08/08/2023, 7:19 PM

Hi Marieke! So, what's happening is probably that plugin depends on an older version of that package that doesn't have binaries for your combination of Python version + Platform. Other folks have solved this using a fork, I think: https://meltano.slack.com/archives/C01TCRBBJD7/p1682365780901819

marieke

08/08/2023, 7:23 PM

Yup - I changed the pip_url to a very unstable custom git

marieke

08/08/2023, 7:23 PM

Still need to see how that will look in cloud

edgar_ramirez_mondragon

08/08/2023, 7:28 PM

Ok, so • the original repo pins

psycopg2-binary==2.8.5

, which doesn't have wheels for Python 3.9+. • the fork mentioned in the thread above pins

psycopg2-binary==2.9.5

, which does have the necessary wheels. @Will Da Silva (Arch) can correct me if I'm wrong but I think Meltano cloud runs on Python 3.9 so only the latter option would work there.

Open in Slack

Previous Next