Need the following functionality in an AWS Lambda function. CSV files can be upto 100 mb so need the ability to handle large files, while keeping the Amazon memory foot print minimal possible.
1. Trigger as file detected in a S3 bucket
2. Load the data from CSV into a table in MySQL database
a. If table does not exist then create it using headers in CSV as column names | Table name is fixed ('InsightData')
b. If table exists, then append the data using 'ResponseID' as primary key
3. When job is done move the file to 'Archive' folder in the bucket
11 freelancers are bidding on average $102 for this job
Hi. I have a lot of experience with amazon lambda and other amazon services and will be happy to help you with processing of csv files. Besides my previous work here also was implementing of lambda functions
I am AWS certified by both freelancer and AWS you need someone with strong AWS skills to get this done correctly, with the correct security and reliability
I'd use a library to connect to mysql db . Relevant Skills and Experience I am Professional Software Developer with over 7 years of experience working for different IT positions
I am a system admin with good experience in AWS. I can help you create this Lambda instance in python. I would need access to create, deploy and test the code.