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 /
  • PlayStream /
avatar image
Question by Andrei Budaes Tanaru · Feb 16, 2021 at 06:06 AM · dataanalyticsscheduled taskstasks

Will Event Export get all historical data or just data from the moment it is activated?

Hi guys,

I am planning to export data into Azure Blobs to ultimately load in Snowflake. I've set the schedule to 1-hour frequency on all events and it currently shows as State=Active and Status=Pending. My questions are:

1. Is it pending for approval by someone (I am an admin) or will it start within an hour

2. Will it export all historical events or all events from the moment I start exporting?

3. If the latter, how can I export all historical too within the same blob?

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 Andrei Budaes Tanaru · Feb 12, 2021 at 02:54 PM

I think I can answer my own question now.

1. The schedule started within an hour and the Data Moved By this Export started increasing in MB

2. It exports only data from the moment the export has been scheduled

3. I tried using the .export function in Kusto but I am not a Studio Admin so I am using the azure.kusto.data package in python to do that.

The current documentation only shows how to connect via an AD app in Azure but found a simpler way.

import azure.kusto.data as akd

import json



client = akd.KustoClient("Data Source=https://insights.playfab.com;AAD Federated Security=True")



db = "{your database/id shown in PlayFab Game Manager}"
query = '''{your kusto query}'''



response = client.execute_mgmt(db, query)
data = json.loads(str(response[0]))['data']

When you run the query, it will print a code and open a Microsoft Authentication window where you need to paste the code.

Comment

People who like this

0 Show 1 · 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 SethDu ♦ · Feb 16, 2021 at 07:25 AM 0
Share

Thanks for the sharing. Please feel free to let me know if you need any other help about event export.

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

    Track game crashes with analytics. 1 Answer

    A simple query in Explorer 1 Answer

    Can we use the new Playfab Data Explorer to query data exported to Azure Blob? 1 Answer

    Bulk Job/schedule tasks limitation 1 Answer

    Viewing Playstream/Insight data with Tableau 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