Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Prefect Community

Hello!

Can anyone recommend how to provision a Prefect Block which supports connecting to AWS Redshift?

using standard postgres `POSTGRESQL_PSYCOPG2` results in a driver which throws the following error on connection:
```sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedObject) unrecognized configuration parameter "standard_conforming_strings"```
This is, apparantly, a known issue: <https://github.com/sqlalchemy/sqlalchemy/issues/9442>


More worryingly, I cannot see any support in Prefect connectors for Redshift. Can anyone advise?

Well that was helpful.

No. Prefect does _not_ support Redshift. At all.

Nor does SQLAlchemy.

You need to use <https://pypi.org/project/redshift-connector/|redshift-connector>.