[TRIGGER] SQLAlchemy

Describe the event source. What app is this for, and what event does the trigger correspond to? I'd like to retrieve data from our redshift data warehouse by using the python sqlalchemy and sqlalchemy-redshift libraries.

Currently receiving the following error Error Command failed: python3 -m pip install --target=/tmp/__pdg__/dist/python -r requirements.txt --upgrade WARNING: The directory '/home/sbx_user1051/.cache/pip' or its parent directory is not owned or is not writable by the current user. The cache has been disabled. Check the permissions and owner of that directory. If executing pip with sudo, you should use sudo's -H flag. ERROR: Cannot install -r requirements.txt (line 4) and SQLAlchemy==2.0.9 because these package versions have conflicting dependencies. ERROR: ResolutionImpossible: for help visit https://pip.pypa.io/en/latest/topics/dependency-resolution/#dealing-with-dependency-conflicts WARNING: You are using pip version 22.0.4; however, version 23.0.1 is available. You should consider upgrading via the '/var/lang/bin/python3 -m pip install --upgrade pip' command.

despite defining the packages in the magic installer # pipedream add-package sqlalchemy-redshift # pipedram add-package SQLAlchemy

import sqlalchemy as sa from sqlalchemy.engine.url import URL from sqlalchemy_redshift.dialect import RedshiftDialect

Please provide a link to the relevant API docs for the specific service / operation this trigger is tied to.

https://pypi.org/project/sqlalchemy-redshift/ https://pypi.org/project/SQLAlchemy/