I am trying to do something (seemingly) simple, but I could not find a good working solution yet: I have a custom event that is fired when player finishes each level, with the level name and the number of moves they made.
I would like to to have a script that would:
1. run a daily/hourly (after each custom event, does not matter)
2. query the playstream and calculate a histogram of moves for that level
3. store the results in Title Data
I know how to do 1 and 3, but I cannot find info about 2.
So far I have seen people recommending to use Snowflake for this (https://community.playfab.com/questions/13765/how-to-retrieve-history-of-player-login-time-and-v.html), but then I found that Snowflake integration was shut down (https://community.playfab.com/questions/35883/data-warehouse-for-storage-and-analysis.html), however links suggested in the answer do not work any more.
Thanks in advance for help!
P.s It this cannot be done, I think I will resort to simply calculating the histogram online as the event is sent, as in "read title data + modify + write". This will not be as precise solution as with the query playstream (as there I could deduplicate by user ID), but it should be good enough.