Microsoft Azure PlayFab logo
    • Multiplayer
    • LiveOps
    • Data & Analytics
    • Add-ons
    • For Any Role

      • Engineer
      • Designer
      • Executive
      • Marketer
    • For Any Stage

      • Build
      • Improve
      • Grow
    • For Any Size

      • Solo
      • Indie
      • AAA
  • Runs on PlayFab
  • Pricing
    • Blog
    • Forums
    • Contact us
  • Sign up
  • Sign in
  • Ask a question
  • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Topics
    • Questions
    • Articles
    • Ideas
    • Users
    • Badges
  • Home /
  • General Discussion /
avatar image
Question by SeanN · Jun 08, 2018 at 02:23 PM · Player DatadataPartner Add-ons

What are best practices to use Snowflake with PlayFab player data?

Hello!

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.

  1. 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
  2. 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.
  3. 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.

Thanks

Comment

People who like this

0 Show 0
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

1 Reply

· Add your reply
  • Sort: 
avatar image
Best Answer

Answer by Brendan · Jun 09, 2018 at 01:45 AM

Well, if 1 means setting up queries that would run on-demand as a response to players on a website, I'd advise against it (since that would mean that an abusive player could drive up your query costs). If you just mean generating daily reports, that's a great use case.

In general, events aren't the best place to manage player data, if you mean all the savegame info for a player. Best to just use the data systems (in particular, Entity Objects and Files) as designed.

But the initial best practice is to make sure to always specify your Title ID, and preferably a timestamp, when querying. That'll help make sure your queries are optimized to your title specifically.

Comment

People who like this

0 Show 2 · Share
10 |1200 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image SeanN · Jun 11, 2018 at 11:14 PM 0
Share

Thanks Brendan,

This is indeed for daily studio reports, nothing a player would be using.

An example of what we may look to accomplish is to run retention reports grouped by information present in Player Data (e.g. male vs female if we were to ask for that information and store it as Player Data)

I understand the storing the data as Entity Objects and Files, but how to utilize that data joined with a report of events so I can say number of logins where Player Data gender = male. I believe just ingesting that data into Snowflake seems the best option versus events for sure. Is there any PlayFab centric way this may be accomplished in the Event History?

Appreciate the help again!

avatar image Brendan ♦♦ SeanN · Jun 12, 2018 at 02:26 AM 0
Share

Sorry, but data simply isn't part of the event system. And events are specifically what you're using for analytics. To get that data into Snowflake so that you can query on it, you would need an event (either one of ours, or a custom event).

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Navigation

Spaces
  • General Discussion
  • API and SDK Questions
  • Feature Requests
  • PlayStream
  • Bugs
  • Add-on Marketplace
  • LiveOps
  • Follow this Question

    Answers Answers and Comments

    2 People are following this question.

    avatar image avatar image

    Related Questions

    Store world objects? 1 Answer

    Where/How to save players personal data? 1 Answer

    Stay logged in when the scene changes 1 Answer

    How to block data operations on player objects until azure function finished? 1 Answer

    Title exceeded limit Player Data Value size when we calculate it as 6800 bytes 1 Answer

    PlayFab

    • Multiplayer
    • LiveOps
    • Data & Analytics
    • Runs on PlayFab
    • Pricing

    Solutions

    • For Any Role

      • Engineer
      • Designer
      • Executive
      • Marketer
    • For Any Stage

      • Build
      • Improve
      • Grow
    • For Any Size

      • Solo
      • Indie
      • AAA

    Engineers

    • Documentation
    • Quickstarts
    • API Reference
    • SDKs
    • Usage Limits

    Resources

    • Forums
    • Contact us
    • Blog
    • Service Health
    • Terms of Service
    • Attribution

    Follow us

    • Facebook
    • Twitter
    • LinkedIn
    • YouTube
    • Sitemap
    • Contact Microsoft
    • Privacy & cookies
    • Terms of use
    • Trademarks
    • Safety & eco
    • About our ads
    • © Microsoft 2020
    • Anonymous
    • Sign in
    • Create
    • Ask a question
    • Create an article
    • Post an idea
    • Spaces
    • PlayStream
    • Feature Requests
    • Add-on Marketplace
    • Bugs
    • API and SDK Questions
    • General Discussion
    • LiveOps
    • Explore
    • Topics
    • Questions
    • Articles
    • Ideas
    • Users
    • Badges