title: Moving bigquery data to Redshift
body: <p>I'm in need to move my bigquery table to redshift.</p>
  
  <p>Currently I have a python job that is fetching data from redshift, and it is incremental loading my data on the redshift.</p>
  
  <p>This python job is reading bigquery data, creating a csv file in the server, drops the same on s3 and the readshift table reads the data from the file on s3. But now the time size would be very big so the server won't be able to handle it.</p>
  
  <p>Do you guys happen to know anything better than this ?</p>
  
  <p>The new 7 tables on bigquery I would need to move, is around 1 TB each, with repeated column set. (I am doing an unnest join to flattening it)</p>