We're enthralled by the Snowflake add-on and the analysis we will be able to achieve with it. One overarching question we have is whether there are any suggested best practices for querying player data along with the PLAYFAB_ARCHIVE_SHARED view.
So far, we are thinking of these options. Any suggestions are much appreciated.
- Build an integration through our own game server that ingests into Snowflake a custom set of tables for players and associated data. This is a bit more timely to setup, but I like that it would allow us to query past events against recently updated player data
- Utilize custom data on events to include all necessary player data per event so we can query against that data in Snowflake. Quicker to setup, but then the player data present in the event when it fires is the only bit available when querying. Changes to the player do not reflect.
- Any other way to ingest player data from PlayFab to Snowflake that doesn't involve building out an integration that we may be unaware of.