sqlalchemy Lambda module import error

Question

I am trying to connect my redshift database from AWS Lambda function. I am getting below error when I try to achieve the connection.

Unable to import module 'lambda_function': No module named 'sqlalchemy'

Below is the import code that I am using in my lambda. I have tried all possible import function. Still noting works. Results in the same error.

from __future__ import print_function

import sqlalchemy as sa
from sqlalchemy.orm import sessionmaker

from flask_sqlalchemy import SQLAlchemy

from flask.ext.sqlalchemy import SQLAlchemy as sa

from flask_sqlalchemy import SQLAlchemy
from sqlalchemy import *
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, String
from sqlalchemy.orm import sessionmaker

sqlalchemy is not preinstalled on lambda so you have to include it in your deployment package: See docs — danielkelemen
– danielkelemen, Commented Nov 7, 2017 at 13:51

Vijayanath Viswanathan · Accepted Answer · 2017-11-07 14:16:06Z

4

As 'sqlalchemy' is not a part of AWS SDK you should include it in your deployment package. If you are deploying it as a .zip file then make sure you have included it in the zip

answered Nov 7, 2017 at 14:16

Vijayanath Viswanathan

8,6713 gold badges31 silver badges50 bronze badges

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

Comments

MClaver89 · Accepted Answer · 2021-10-01 14:23:31Z

0

Put this lib in a Layer and import in your code, maybe this solve your problem. Like Vijayanath Viswanathan saw, build a layer with .zip file.

answered Oct 1, 2021 at 14:23

MClaver89

614 bronze badges

Collectives™ on Stack Overflow

sqlalchemy Lambda module import error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related