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,510 points
2,682 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
• 57,700 points

Related Questions In AWS

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 in AWS by MD
• 66,500 points
44 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,150 points
1,545 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
4,285 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 26, 2018 in DevOps & Agile by DragonLord999
• 8,450 points
732 views
+1 vote
2 answers

AWS CloudWatch Logs in Docker

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

answered Sep 6, 2018 in AWS by bug_seeker
• 15,510 points
780 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 25, 2019 in AWS by Priyaj
• 57,700 points
2,849 views