A quick way to connect to MS SQL from AWS Lambda using Lambda Layers.

pyodbc

pyodbc is an open-source Python module that makes accessing ODBC databases simple. It implements the  DB API 2.0 specification but is packed with even more Pythonic convenience. This was built to bridge the odbc connection using python.

Step 1 :

Download only the required file according to your python version. Unpack the .so files in the working directory.

#serverless #aws-lambda #aws