How to load CSV data to RDS Aurora table using lambda

+1 vote

I have one csv file stored into the amazon s3 . What i want to do is read that csv file using Lambda and save that to RDS Aurora (Note : Check here if data is exist then update or insert that data) . After inserting all data i want to take dump of them back to amazon s3 .

How can i perform this tasks , any help would be great

Jul 26, 2018 in AWS by bug_seeker
• 15,520 points
4,560 views

1 answer to this question.

0 votes

Launch an Amazon RDS MySQL database engine instance in your default Amazon VPC. In the MySQL instance, you create a database (ExampleDB) with a sample table (Employee) in it. For more information about Amazon RDS, see Amazon RDS.

  • Create a Lambda function to access the ExampleDB database, create a table (Employee), add a few records, and retrieve the records from the table.

  • Invoke the Lambda function manually and verify the query results. This is how you verify that your Lambda function was able to access the RDS MySQL instance in the VPC.

Important

This tutorial uses the default Amazon VPC in the us-east-1 region in your account. For more information about Amazon VPC, see How to Get Started with Amazon VPCin the Amazon VPC User Guide.

answered Jul 26, 2018 by Priyaj
• 58,100 points

Related Questions In AWS

+1 vote
1 answer
0 votes
1 answer

how to get the RDS snapshot list last 24 hours list by using the lambda functions

Hi@shalk, You can list down your RDS snapshot. ...READ MORE

answered Sep 24, 2020 in AWS by MD
• 95,460 points
2,995 views
0 votes
1 answer

How to set-up DynamoDB trigger using AWS Lambda?

Well this code worked for me. You ...READ MORE

answered Aug 20, 2018 in AWS by Archana
• 4,170 points
2,804 views
0 votes
2 answers

How to skip headers when reading a CSV file in S3 and creating a table in AWS Athena?

Thanks for the answer. This should be clear ...READ MORE

answered Aug 14, 2019 in AWS by athenauserz
11,736 views
+15 votes
2 answers

Git management technique when there are multiple customers and need multiple customization?

Consider this - In 'extended' Git-Flow, (Git-Multi-Flow, ...READ MORE

answered Mar 27, 2018 in DevOps & Agile by DragonLord999
• 8,450 points
3,942 views
+1 vote
2 answers

AWS CloudWatch Logs in Docker

The awslogs works without using ECS. you need to configure ...READ MORE

answered Sep 7, 2018 in AWS by bug_seeker
• 15,520 points
1,964 views
0 votes
1 answer

How to load data into a table in DynamoDB using Java?

You can create a .json file with the ...READ MORE

answered Feb 26, 2019 in AWS by Priyaj
• 58,100 points
6,861 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP