title: S3 to MySQL AWS Data Pipeline Insert table error
body: <p>It's my first time asking a question on here, please so bear with me</p>
  
  <p>I am trying to create a data pipeline to upload a CSV file in an S3-Bucket to a MySQL database table(Production1) using the template provided by aws, but fails when executing RdsMySqlTableCreateActivity. </p>
  
  <p>The sql statement that I'm using(all column names match the CSV file) in the myRDSTableInsertSql parameter:</p>
  
  <pre><code>INSERT INTO `Production1` (`API`, `Normalized Month`, `DATE`, `Monthly Liquid`, `Cum Oil`, `BOPD`, `Monthly Gas Mcf/Month`, `Cum Gas`, `MCFPD`) VALUES(?,?,?,?,?,?,?,?,?);
  </code></pre>
  
  <p>The RdsMySqlTableCreateActivity error: </p>
  
  <pre><code>errorId
  ActivityFailed:SQLException
  errorMessage
  No value specified for parameter 1
  errorStackTrace
  amazonaws.datapipeline.taskrunner.TaskExecutionException: 
  private.com.amazonaws.services.datapipeline.redshift.QueryStatementException: Exception No value specified for 
  parameter 1 while executing INSERT INTO `Production1` (`API`, `Normalized Month`, `DATE`, `Monthly Liquid`, `Cum Oil`, `BOPD`, `Monthly Gas Mcf/Month`, `Cum Gas`, `MCFPD`) VALUES(?,?,?,?,?,?,?,?,?);... 
  </code></pre>
  
  <p>I ran the insert command on MySQL workbench, replacing the <code>(?,?,?,?,?,?,?,?,?)</code> with <code>(1,2,3,4,5,6,7,8,9)</code>, and it worked. The CSV file that I'm using only has 2 rows the column names and values 1-9 for each column respectively. Really not sure what it means by <code>No value specified for parameter 1</code>, any help/guidance would really be appreciated!!!</p>