title: Should I CREATE TABLE every time I run COPY command
body: <p>I have been tasked with moving MySQL databases to amazon redshift.  Currently I am attempting to accomplish this by </p>
  
  <p>1) converting tables to CSV files</p>
  
  <p>2) storing them in S3</p>
  
  <p>3) creating a table in redshift</p>
  
  <p>4) using the COPY command to transfer the data from S3 to redshift</p>
  
  <p>I am using Python to attempt to automate this process and use boto3 to encrypt the data on the way to S3.</p>
  
  <p>However, with the process I have now, I would have to manually create a table in Redshift for every csv in S3.  Since I am ultimately going to move lots of data, this is going to be very inefficient.</p>
  
  <p>Is there a code I can run to detect the schema and create the table without having to go in and change the CREATE TABLE statement every time I want to load new data?</p>