Can't load plugin: sqlalchemy.dialects:psycopg2 about sqlalchemy-redshift HOT 11 CLOSED

@rosner I'm going to need the example code.

Can you create a minimal failing case and post it on github?

from sqlalchemy-redshift.

In particular, what's in your connection string? From the output, I'm suspecting it might be prefixed with psycopg2:// where it needs to be redshift+psycopg2://

from sqlalchemy-redshift.

@jklukas sorry I pasted the wrong exception message. I first tried with redshift+psycopg2://user:[email protected]:5439/dev

and then tried different things (postgres:// and redshift:// only for example).

from sqlalchemy-redshift.

@rosner I'm going to need the example code.

Can you create a minimal failing case and post it on github?

from sqlalchemy-redshift.

@graingert here's the snippet with which I can reproduce it:

import sqlalchemy as sa
sa.create_engine('redshift+psycopg2://user:[email protected]:5439/dev')

I tried this in a clean venv.

from sqlalchemy-redshift.

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
    import sqlalchemy as sa
ImportError: No module named 'sqlalchemy'

from sqlalchemy-redshift.

I tried this in a clean venv.

perhaps this is your issue?

from sqlalchemy-redshift.

Seriously, can you actually create the project in GitHub and reproduce the failure with Travis.

from sqlalchemy-redshift.

Yeah you're right, I'm not really helpful without giving more context. Will try to reproduce it and get back.

from sqlalchemy-redshift.

Alright I finally got back to this. And I didn't manage to reproduce it with a travis setup. So I'm closing this and sorry for the "trouble" again. Thanks a ton for reacting that quickly. It's still puzzling what's going on in that specific venv but that's not an issue for this project.

from sqlalchemy-redshift.

Error : Can't load plugin: sqlalchemy.dialects:psycopg2
I Have faced the same issue when set the variable clerny result backend:
AIRFLOW__CELERY__RESULT_BACKEND: "db+psycopg2://{{ .Values.postgresql.postgresqlUsername }}:{{.Values.postgresql.postgresqlPassword }}@airflow-postgresql-headless:{{ .Values.postgresql.service.port }}/airflow"
Reslove this issue by Changes the string value :
Must install python pip modules:
1.psycopg2-binary
2.sqlalchemy
3.sqlalchemy-redshift
Than change the CELERY__RESULT_BACKEND value to :
AIRFLOW__CELERY__RESULT_BACKEND: "db+postgresql://{{ .Values.postgresql.postgresqlUsername }}:{{.Values.postgresql.postgresqlPassword }}@airflow-postgresql-headless:{{ .Values.postgresql.service.port }}/airflow"

from sqlalchemy-redshift.