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,550 points
3,353 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,140 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,320 points
923 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,915 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
6,996 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
1,324 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,550 points
1,069 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,140 points
3,991 views