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

Kim Strasser 746 Reputation points
2021-09-09T09:00:36.447+00:00

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:
130722-bildschirmfoto-2021-09-08-um-181800.png

But in Azure Data Explorer Database the columns for the same 3 events look like this:
130670-bildschirmfoto-2021-09-08-um-182411.png

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?

Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
497 questions
0 comments No comments
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA-MSFT 83,301 Reputation points Microsoft Employee
    2021-09-10T08:38:15.497+00:00

    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.

    131053-image.png

    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.

    131016-image.png

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

    130996-image.png

    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 130616-image.png or upvote 130671-image.png 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

0 additional answers

Sort by: Most helpful