question

Natali avatar image
Natali asked

How to execute sql query for insights in cloud script?

I created a table ['custom.game'] in insights explorer in playfab

And I 'd like to know how can i manage this table from cloud script?

Anyone can help me?

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Citrus Yan avatar image
Citrus Yan answered

Currently PlayFab supports connecting the following external tools to Insights:

  • Power BI
  • Kusto Explorer
  • Azure Data Explorer (ADX)
  • Azure Data Factory (ADF)
  • Grafana
  • Python
  • Kusto C# SDK

https://docs.microsoft.com/en-us/gaming/playfab/features/insights/connectivity/#kusto-explorer

And, since the legacy CloudScript uses JavaScript, which currently does not support connecting to Insights. Therefore, in your case, you may use the new PlayFab CloudScript using Azure Functions feature, which uses Azure Functions to run cloud code, along with Kusto C# SDK to query Insights from Azure Functions.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.