title: Loading JSON files to Redshift
body: <p>I am trying to use the copy command to load a bunch of JSON files on S3 to redshift. Example structure of the JSON file is:</p>
  
  <pre><code> {
   message: 3
   time: 1521488151
   user: 39283
   information: {
       bytes: 2342343
       speed: 9392
       location: CA
   }
   }
  </code></pre>
  
  <p>Is it possible to create a table with the correct columns - splitting up the information block to individual columns as well and use copy command?</p>