psycopg2.errors.UndefinedObject: unrecognized configuration parameter "standard_conforming_strings"

[W-Ely]

Expected Behavior

Databuilder installs and runs without error

Current Behavior

When running against AWS Redshift on a clean python pip install of databuilder we get error: psycopg2.errors.UndefinedObject: unrecognized configuration parameter "standard_conforming_strings" This is due to databuilder loosely versioning SQLAlchemy here

Possible Solution

Pin SQLAlchemy here and here like sqlalchemy>=1.3.6,<2.0.0

Screenshots (if appropriate)

Context

Your Environment

• Amunsen version used: databuilder-7.4.3
• Data warehouse stores: AWS Redshift
• Deployment (k8s or native): N/A
• Link to your fork or repository: N/A

[boring-cyborg[bot]]

Thanks for opening your first issue here!

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.

[stale[bot]]

This issue has been automatically closed for inactivity. If you still wish to make these changes, please open a new pull request or reopen this one.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.