how to send data from s3 to RDS MySQL using lambda function

0

i have zip files which contains excel sheets of data whenever new zip file uploads to s3 it has to unzip and store all excel sheets data as MySQL tables how to achive this using lambda function

1개 답변
0
수락된 답변

Hi,

Not sure if you expecting the complete solution here, hope you are not :) Let me add some more details to your workflow:

  1. You can trigger Lambda when a new file is uploaded to the S3. Some examples you can find here: https://docs.aws.amazon.com/lambda/latest/dg/with-s3-example.html
  2. You need to write your custom Lambda function, which will unarchive, validate and parse Excel file and insert data to your RDS MySQL database. There are plenty of libraries available for any programming language you prefer.

Hope it helps.

profile picture
전문가
답변함 8달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠