title: Automate bulk loading of data from s3 to Aurora MySQL RDS instance
body: <p>I am relatively new to AWS so I am not sure how to go about doing this,</p>
  
  <p>I have CSV files on s3 and I have already set up the Aurora instance on RDS. The thing that I am unable to figure out is how do I automate the bulk loading of data, essentially doing like a <code>LOAD DATA FROM s3</code> kind of thing using something like AWS Glue.</p>
  
  <p>I also used the Glue native thing of s3 to RDS, but then it is essentially a bunch of inserts into RDS over a JDBC connection which is also super slow for large datasets.</p>
  
  <p>I can do it independently running the command on RDS but I do not want to do that and want to leverage Glue. I also looked at using a MySQL connector for Python but Glue natively only supports Python 2.7 which is something that I do not want to use.</p>
  
  <p>Any help would be greatly appreciated.</p>