Using SQLAlchemy in AWS LAMBDA

Question

I am trying to use SQL Alchemy in AWS Lambda function but it is throwing error:

module not found.

Also I am attaching the folder structure which I am deploying to Lambda layer after zipping.

I am using the following command to create the folder for lambda layer.

pip3 install sqlalchemy --target Alchemy_layer/

Jens · Accepted Answer · 2021-06-30 14:01:18Z

3

The layer needs a different folder structure according to the documentation.

Try this:

pip3 install sqlalchemy --target python/
zip -r sqlalchemy-layer.zip python/

Upload that ZIP as layer and try again.

answered Jun 30, 2021 at 14:01

Jens

21.7k11 gold badges64 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1