Load csv file from S3 to RDS Mysql using AWS data pipeline

Question

I'm new to AWS, trying to load data from csv file to RDS MySQL using data pipeline "load S3 data into RDS mysql table" template. But getting error "DriverClass not found for database:aurora". Tried setting JDBC uri property point to driver jar in s3.

Thanks!

sticky bit · Accepted Answer · 2018-05-21 03:53:22Z

2

Export pipeline you just created from template and change RDS properties for the following:

{
      "*password": "#{*myAuroraPassword}",
      "name": "aurora",
      "connectionString" : "jdbc:mysql://hostname:port/dbname",
      "jdbcDriverClass" : "com.mysql.jdbc.Driver",
      "id": "aurora",
      "type": "JdbcDatabase",
      "username": "#{myUsername}"
}

edited May 21, 2018 at 3:53

sticky bit

37.7k12 gold badges34 silver badges46 bronze badges

answered May 21, 2018 at 3:27

herbertgoto

3591 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

Load csv file from S3 to RDS Mysql using AWS data pipeline

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related