Tag: aws-lambda

Concatenate variable in Athena SQL query from Python Lambda function

I have a Python Lambda function that creates a SQL table in Athena. How do I properly concatenate variables in my query? When I set the LOCATION value, I receive the error response below. The function runs successfully if I hard code the LOCATION value. Error response: Lambda function: Thank you. Answer Have you tried to use Python’s format method?

Pyodbc and AWS Lambda

aws-lambda pyodbc python sql

I have a fairly simple SQL query that’s taking forever to run in my Lambda function and I don’t know why. I know OR statements can be a killer in SQL, but in my database editor, it runs in about 800ms. Why would it take longer in a Lambda function? I’m using cursor.execute() and passing the SQL statement. SQL Query: