Skip to content

Amazon Redshift Dialect for SQLAlchemy

4

Presently cannot upgrade my version of python SQLAlchemy to version 2.0 because redshift dialect doesnt support it. There is an open github issue on this: https://github.com/sqlalchemy-redshift/sqlalchemy-redshift/issues/264 ...but there has been no movement on this in a long time.

This is starting to be a big issue because SQLAlchemy tightly integrates with Pandas and pandas is targeting SQLAlchemy 2.0. We're starting to be in a situation where we cannot upgrade versions of pandas because of this.

asked 2 years ago655 views
3 Answers
1

I would also like to echo this post, this is a huge problem and the support team should consider reaching out to brooke white @ AWS, the author of said library.

answered a year ago
0

I'm also echoing this post. Is there any way AWS could reach out to the maintainer of sqlalchemy-redshift to help facilitate transfer of ownership? AWS does reference sqlalchemy-redshift in a blog post, which should likely be removed if there's no plans to get sqlalchemy-redshift compatabile with SQLAlchemy 2.* https://aws.amazon.com/blogs/big-data/use-the-amazon-redshift-sqlalchemy-dialect-to-interact-with-amazon-redshift/

answered 10 months ago
-2

Hi,

If I understand correctly, you are not able to upgrade the version of python SQLAlchemy to version 2.0 as Redshift Dialect does not support it. As mentioned by you we already have a git issue open on it on which there are no recent updates. Hence , I would recommend opening a support case to determine if this can be raised a feature request or if there is any other suggestion from our service team for alternative solution.

Apologies for the inconvenience caused to you.

AWS
answered a year ago
  • How do i open a support case? btw I would point out that the github issue requesting support for SQLAlchemy 2.0 is the most commented issue in that repository. And, judging from the comments, there's a lot of frustration / negativity building around the issue.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.