I have a Route53 entry for *.example.com pointing to my load balancer. Almost all the requests contain agent and source parameters. I want to parse the url and add 4 new fields: customer, agent, agent_int, source in the table.
With the new fields like customer and agent_int it will be very simple for me to query the logs based on a range of values. Is it possible to parse the request_url and extract this information? Some amount of transformation is also required (e.g. agent_int = (X*100+Y)*100+Z where agent format is X.Y.Z)