My app engine instances are logging incoming requests and I'd like to be able to run manual/one-off queries for data analysis.
As an example, I would like to be able to determine how many requests are made to each end-point, within a given period. So an SQL query might look something like this:
SELECT path, count(path) FROM request_log WHERE time >= :start_time AND time <= :end_time GROUP BY path
What is the simplest and most cost effective way to achieve these kinds of queries based on logging data?
Note: Monthly log ingestion is just under 1TB.