Storing data into AWS Aurora Mysql through Lambda?

Question

I want to run Lambda once daily which would query third-party API and returned data needs to be stored in Aurora MySQL database. Is it even possible to save data in Aurora directly through Lambda. After reading docs, the only way possible is via text files saved in S3 which is also through command line Interface using LOAD DATA FROM S3 statement and not through AWS SDK or API call.. Is that so or Am I missing something? Is there any way I can achieve desired results Lambda--->Aurora through SDK or API calls.

Thanks in advance. Pardon me if I am sounding silly

Have you seen this example? docs.aws.amazon.com/lambda/latest/dg/services-rds-tutorial.html — alexis-donoghue
– alexis-donoghue, Commented May 25, 2020 at 17:42
hmm.. thanks for sharing the link. I was in impression that Aurora DB is different than usual MySQL or Postgresql and hence different ways to connect to Aurora... — Poonam
– Poonam, Commented May 26, 2020 at 12:53

Chris Williams · Accepted Answer · 2020-05-25 17:47:05Z

0

Take a look at RDS Proxy: https://aws.amazon.com/rds/proxy/. This should allow you to interact.

answered May 25, 2020 at 17:47

Chris Williams

35.7k4 gold badges46 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Poonam Over a year ago

Thanks for the suggestion. It looks like can solve the problem

Chris Williams Over a year ago

Glad I helped :)

Collectives™ on Stack Overflow

Storing data into AWS Aurora Mysql through Lambda?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related