Why does Azure Data Explorer Database not displaying everything in the columns?

Question

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?

Answer 1

Hello @Kim Strasser ,

Thanks for the question and using MS Q&A platform.

First issue: 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.

You may try the below options and see if the issue with Azure Data Explorer.

Option1: Try to query the table from Azure Portal.

Option2: In case if you still unable to see all the columns, you please try the below and do let us know.

• Clear “Cookies and Cached data” of your browser.
• Private Mode (New InPrivate Window).
• Try in different browser.

Second issue: The query which you shared above.

The code contains two lines -

• Line1 - This query create a table
• Line2 - This query create the JSON mapping

Note: You are not ingested JSON data into the table you have create just table and schema.

You can get the details about the table by running the command - .show table <TableName> details

For more details, refer to Ingest JSON formatted sample data into Azure Data Explorer

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators