title: Loading parquet file to Redshift
body: <p>I am trying to save dataframes to parquet and then load them into redshift.
  For that i do the following:</p>
  
  <pre><code>parquet_buffer = BytesIO()
  df.to_parquet(parquet_buffer,index=False,compression='gzip')
  s3.Bucket(write_bucket).put_object(Key=write_path,Body=parquet_buffer.getvalue())
  </code></pre>
  
  <p>I then load the saved file directly into redshift using the "COPY" command:</p>
  
  <pre><code>COPY table_name
  from write_path
  iam_role my_iam_role
  FORMAT AS PARQUET
  </code></pre>
  
  <p>It leads the following error:
  <code>write path: has an incompatible Parquet schema for column ...</code></p>
  
  <p>If I apply the same procedure with .csv It works just fine. What causes the problem when switching to parquet?</p>