I am somewhat confident this is the correct approach but I need a little sanity check before setting out on this.
I want to record a numerical value for a category over time. There will be many categories and may appear as follows:
1 cat_1 4 cat_2 10 cat_3 4 cat_4 10 cat_5 8 cat_6 99 cat_7 4 cat_8
Say, the count (on the left) on the left will be different each time I poll for the data.
I will want to run analysis on this later on.
My plan is to store the data each time I poll for it in a JSON encoded object in S3 (along with the timestamp). This means it will be in raw form.
Later on I will want to query that information to see the values per category over time.
Will this be sufficient and easy to analyse later?