Modelling logs for improved lookup

antho
Participant IV

Hello,

I’m contacting you in order to get some advice on a data modelling use case I’m facing.

We are analyzing application logs using Amazon Athena. Basically, the table looks like this:

I would like to be able to extract some information stored in the JSON raw in order to filter on a complete Session ID but the issue is that these informations stored in this JSON raw are not repeated in the current logs table. I’m convinced there is a way to model this using derived tables but I’m not sure exactly how to proceed.

Any idea?
Thanks a lot!

Antho

0 0 47
0 REPLIES 0
Top Labels in this Space
Top Solution Authors