title: Is Athena a viable/sensible choice for infrequently searching *unstructured* JSON?
body: <p>I'm recording request and response headers and bodies for all traffic to our API and <strong>from</strong> our API to 3rd party services into S3 as into tiny objects.</p>
  <p>I want to be able to query this data infrequently. For example (pseudo-code):</p>
  <pre><code>select $.cars[0].color from &quot;objects&quot; where object_path in (....);
  </code></pre>
  <p>Other info:</p>
  <ul>
  <li>Many &quot;objects&quot; in S3 won't have a valid path to <code>$.cars[0].color</code> (it's just one example).</li>
  <li>I hope to not use Glue.</li>
  <li>Cost is important - this is something that will be queried <em>very</em> infrequently. Configuring some ElasticSearch/similar solution is terribly out of budget for the use case.</li>
  <li>I hope to not define my own set of schemas (this is simply not feasible).</li>
  </ul>
  <p>Athena says it can search unstructured JSON. I'm having trouble creating a proof-of-concept to show this is true.</p>
  <p>Is Athena right fr me? Am I missing a better solution?</p>