I have been trying to query the catalog items and currency using a KQL in the data explorer. I can only see the events inside the data explorer. I know that there are REST API endpoints to get the data. Is it possible to query the catalog items and similar internal data using KQL (or any SQL)?
Answer by Rick Chen · Oct 08, 2021 at 08:57 AM
In PlayFab, the events.all table is the default destination for all incoming events and you can only do the KQL on that table. If you want to be able to do the KQL on the Catalog, you can create your own table and store the Catalog data in that table. For more detail about creating table and do the data ingestion, you can refer to the following documents: