That would be great.

Do you have a pattern on how to automatically inject RDS' creds via Lambda/boto3/SecretsManager maybe?

Hi, I think what you are doing is great. If others want other people to contribute, can you please update the readme to add the steps to create additional lambda layers for other packages?

For example, I would like to add pyodbc for python 3.10

Whenever I try to connect with database it(pyodbc) is throwing error "('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)') ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')" on aws lambda.

I have done all the things mention in your medium blog but still getting the above error.

Please provide a build script for this so people can recreate the layer as needed, for multiple reasons:

1. Security - how can we trust your code and the binaries?
2. Maintainability - need the ability to update to new versions of drivers and Python modules.

Thanks

Hi, first of all thanks for your work.

I created a 3.7 lambda on aws console.
Copy paste your sample python code directly on the lambda code editor.
Upload the layer zip file and attach to lambda.
Did a very simple test, but the response is:

{
"errorMessage": "('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found (0) (SQLDriverConnect)")",
"errorType": "Error",
"stackTrace": [
" File "/var/task/lambda_function.py", line 10, in lambda_handler\n conn = pyodbc.connect('Driver={SQL Server};'\n"
]
}

code:

The layer attached

Able to 'Import pyodbc' ,However, could not connect to MYSQL server.
"errorMessage": "('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')",
What could be the possible reason for this in AWS lambda?