I have created a new table in Azure Data Explorer Database but something is not working with my events.
In PlayFab Data Explorer (advanced) the columns look like this:
But in Azure Data Explorer Database the columns for the same 3 events look like this:
Why does Azure Data Explorer Database not displaying everything in the columns? Only 2 columns have entries in Azure Data Explorer Database but in PlayFab Data Explorer (advanced) many more columns have entries.
I have created my table in Azure Data Explorer Database like this:
.create table NewTestTable (SchemaVersion: string, FullName_Namespace: string, FullName_Name: string, Entity_Id: string, Entity_Type: string, EntityLineage_title: string, EventData: dynamic, EventId: string, Timestamp: datetime, EntityLineage_title_player_account: string, EntityLineage_master_player_account: string, EntityLineage_namespace: string, ExperimentVariants: dynamic, Originator_Id: string, Originator_Type: string)
.create table NewTestTable ingestion json mapping 'NewTestMapping' '[{"column":"SchemaVersion","path":"$.SchemaVersion"},{"column":"FullName_Namespace","path":"$.FullName_Namespace"},{"column":"FullName_Name","path":"$.FullName_Name"},{"column":"Entity_Id","path":"$.Entity_Id"},{"column":"Entity_Type","path":"$.Entity_Type"},{"column":"EntityLineage_title","path":"$.EntityLineage_title"},{"column":"EventData","path":"$.EventData"},{"column":"EventId","path":"$.EventId"},{"column":"Timestamp","path":"$.Timestamp"},{"column":"EntityLineage_title_player_account","path":"$.EntityLineage_title_player_account"},{"column":"EntityLineage_master_player_account","path":"$.EntityLineage_master_player_account"},{"column":"EntityLineage_namespace","path":"$.EntityLineage_namespace"},{"column":"ExperimentVariants","path":"$.ExperimentVariants"},{"column":"Originator_Id","path":"$.Originator_Id"},{"column":"Originator_Type","path":"$.Originator_Type"}]'
Is something wrong with this code or why does Azure Data Explorer Database not displaying everything in the columns?



or upvote
button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is