title: Load Parquet files into Redshift
body: <p>I have a bunch of Parquet files on S3, i want to load them into redshift in most optimal way.</p>
  
  <p>Each file is split into multiple chunks......what is the most optimal way to load data from S3 into Redshift?</p>
  
  <p>Also, how do you create the target table definition in Redshift? Is there a way to infer schema from Parquet and create table programatically? I believe there is a way to do this using Redshift spectrum, but i want to know if this can be done in scripting.</p>
  
  <p>Appreciate your help!</p>
  
  <p>I am considering all AWS tools such as Glue, Lambda etc to do this the most optimal way(in terms of performance, security and cost).</p>