Edit

Tutorial: Connecting Kusto Explorer to Insights

  • Article

This guide helps you get started using Kusto Explorer along with Insights. After connecting, you can use Kusto Explorer to query and explore your game data. To learn more about other tools you can connect Insights with, see Connecting external tools to Insights.

Prerequisites

PlayFab account authenticated with AAD

You need a PlayFab account or user for which the authentication provider is set to Microsoft. The Microsoft authentication provider uses Azure Active Directory (AAD) for authentication which is required to use the Azure services. See Azure Active Directory Authentication for Game Manager for instructions on creating an AAD-authenticated account or user.

To verify that the account, or user, is set to use the Microsoft authentication provider:

If you can sign in, then the account is set to use the Microsoft authentication provider.

Game Manager permissions for Insights

You need to assign your account a user role with the following Game Manager permissions enabled:

  • Admin status.
  • Access to the Explorer tab and associated data.
  • Read and write access to Analytics data.

You can either create a new user role or add these permissions to an existing role.

Other prerequisites

Important

Insights only supports the V1 query response schema. You can update the response schema in Kusto Explorer using the steps below.

On your local machine, open Kusto.Explorer.

  1. Select the Tools tab, then select Options...

  2. Under the Connections category, change the following two properties:

    • Set Query results protocol to V1 from the dropdown options.
    • Set KQL Parser version to V1 from the dropdown options.

    Kusto.Explorer use V1 query schema

Connect with Kusto Explorer

On your local machine, open Kusto.Explorer.

  1. Add a connection. You can do this in two different ways:

    • Select the Connections tab, then select Add connection.
    • Right-click on the Connections folder in the left navigation panel, then select Add connection.

  2. In the Add connection dialog box:

    • Under Cluster connection enter the PlayFab API endpoint, which is https://insights.playfab.com.
    • Under Security, make sure AAD Federated is selected.
    • Expand the Advanced: Connection String box and change the value of Initial Catalog from NetDefaultDB to <titleID>. Note that <titleID> must be all uppercase here. In the example below, this change is highlighted in the string.

    Kusto.Explorer add connection

  3. Select OK, and you should now be able to visualize the results of the query.

Additional resources