title: Duplicate Table in AWS Glue using AWS Athena
body: <p>I have a table in AWS Glue which uses an S3 bucket for it's data location. I want to execute an Athena query on that existing table and use the query results to create a new Glue table.</p>
  
  <p>I have tried creating a new Glue table, pointing it to a new location in S3, and piping the Athena query results to that S3 location. This almost accomplishes what I want, but </p>
  
  <ol>
  <li>a .csv.metadata file is put in this location along with the actual .csv output (which is read by the Glue table as it reads all files in the specified s3 location). </li>
  <li>The csv file places double quotes around each field, which ruins any fieldSchema defined in the Glue Table that uses numbers</li>
  </ol>
  
  <p><strong>These services are all designed to work together, so there must be a proper way to accomplish this. Any advice would be much appreciated :)</strong></p>