title: Athena - Creating a Dynamic JSON Column
body: <p>I'm in a bit of a dilemna here:</p>
  
  <p>I'm using AWS Athena to query against some JSON objects. Most of the JSON records are structured, but one field in particular ("changes") has dynamic objects whose fields don't really have a set structure. For example, here's a record: </p>
  
  <pre><code>{
      id: 1,
      user_id: 2,
      changes: {
      "customer_id" 1,
      "business_name: ['old name', 'new name']
      }
  }
  </code></pre>
  
  <p>Every record has different keys and the value types vary. How can I represent this data? I thought maybe a string, but when I try to store it that way I get JSON parsing errors when decoding. Any help would be appreciated! Thanks!</p>