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ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ