PipedreamHQ / PipedreamHQ/pipedream

[TRIGGER] SQLAlchemy

Open
#5,965 1 comment 0 reactions 0 assignees View on GitHub
enhancement good first issue help wanted triaged trigger / source
Dominant language
JavaScript
Stars
11.7k
Forks
5.8k
Avg merge
3d 10h
Merged PRs (30d)
102

Description

**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/

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.