Hi Everyone Im facing the below error while trying to depoy

Question

Hi Everyone Im facing the below error while trying to depoy dagster to openshift using azure pipeline My deployment worked well for a long time but i get this error now kindly assist ImportError cannot import name BindParamClause from sqlalchemy sql expression usr local lib python3 7 site packages sqlalchemy sql expression py

Adam Bloom · Answer

If you update to the latest release that s resolved Alternatively add an explicit dependency to sqlalchemy lt 2 0 0

Adam Bloom · Answer

They sqlalchemy released a major version upgrade and older dagster releases did not have an upper bound on the dependency so pip is likely installing the new incompatible version since nothing is telling it not to

Vinu Praveen · Answer

Thanks Adam for the response could you also let me know if I can add it like below in my docker file RUN pip install dbt core dbt sqlserver dagster==$ DAGSTER VERSION dagster azure==$ DAGSTER VERSION dagster postgres==$ DAGSTER VERSION dagster k8s==$ DAGSTER VERSION dagster aws==$ DAGSTER VERSION dagster celery flower redis kubernetes ==$ DAGSTER VERSION dagster celery k8s==$ DAGSTER VERSION dagster gcp==$ DAGSTER VERSION dagster graphql==$ DAGSTER VERSION dagit==$ DAGSTER VERSION sqlalchemy lt 2 0 0

Vinu Praveen · Answer

yes the above worked with sqlalchemy lt 2 0 0 thankyou