import boto3 import pymssql
ssm = boto3.client('ssm')
def lambda_handler(event, context): # retrieve database credentials from AWS Systems Manager Parameter Store username = ssm.get_parameter(Name='/myapp/db_username', WithDecryption=True)['Parameter']['Value'] password = ssm.get_parameter(Name='/myapp/db_password', WithDecryption=True)['Parameter']['Value']
# connect to SQL Server database
conn = pymssql.connect(server='myapp.database.windows.net', user=username, password=password, database='mydb')
# execute query
cursor = conn.cursor()
cursor.execute('SELECT * FROM mytable')
rows = cursor.fetchall()
# return result
return {
'statusCode': 200,
'body': rows
}