Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Replace sqlalchemy-redshift with supported library like redshift-connector #9845

Open
VolkovGeoPhy opened this issue Apr 30, 2024 · 1 comment
Labels
dependencies PR or issue that updates a dependency redshift AWS Redshift Related

Comments

@VolkovGeoPhy
Copy link

Is your feature request related to a problem? Please describe.
FOr redshift right now GX uses sqlalchemy-redshift which is barely alive. This project is not developed properly.
Can we use something like redshift-connector

Describe the solution you'd like
I'd like to have mantainable libraries in project's dependancies

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context

@Kilo59 Kilo59 added redshift AWS Redshift Related dependencies PR or issue that updates a dependency labels May 1, 2024
@Kilo59
Copy link
Member

Kilo59 commented May 14, 2024

@VolkovGeoPhy what happens if you install this dependency locally and attempt to use it as the data-connector?

The documentation for sqlalchemy-redshift says that it can use either redshift_connector or pyscopg2.

This dialect requires either redshift_connector or psycopg2 to work properly. It does not provide it as required, but relies on you to select the distribution you need
https://github.com/sqlalchemy-redshift/sqlalchemy-redshift?tab=readme-ov-file#installation

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
dependencies PR or issue that updates a dependency redshift AWS Redshift Related
Projects
None yet
Development

No branches or pull requests

2 participants