title: Copying json objects with multiple layouts from S3 into Redshift
body: <p>I have an S3 bucket with many files containing "\n" delimited json objects. These json objects can have a few different layouts. There is a standard set of keys that are common across all the layouts. Most differences just have a few extra keys, but some have nested json objects. One file can have any/all of these layouts.</p>
  
  <p>I have managed to define a single, basic table in Redshift and copy the data into that table, but any keys not in my table are lost. </p>
  
  <p>I would like to create 1 table for each layout I have and have the json object copied into the appropriate table. The layouts with nested json objects could probably stay in a single string column as json since Redshift is able to parse json in a query. </p>
  
  <p>I am new to AWS, so any help would be appreciated. Also, feel free to suggest non-Redshift services that might work as well.</p>
  
  <p>Thanks!</p>