amazon web services - Filtering and reporting on big data interactively

Question

We need to have a table with about 100,000 records being inserted every day. It's a very wide table with 30-40 attributes, and the application needs to filter on it with any combination of those attributes and render the dataset.

Similarly, based on the filters selected by the user on the web app, Aggregate queries need to be running to render the charts forex: top n importers, top n importers with hscode =x and port=y and so on and so forth.

We can make the year filter mandatory to reduce the scan but the rest of everything is based on the user's filtration criteria.

How should this use-case be handled using AWS managed services for the best speed? This is an interactive application with the user selecting the filters and expecting the charts/data without much lag.

question from:https://stackoverflow.com/questions/65843273/filtering-and-reporting-on-big-data-interactively

Answer 1

Waitting for answers