question

42315514 avatar image
0 Votes"
42315514 asked PRADEEPCHEEKATLA-MSFT commented

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @42315514,

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


image.png (140.1 KiB)
image.png (132.4 KiB)
image.png (67.9 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Is it possible to edit the ingestion json mapping settings of my table? I used the wrong settings when I created the columns.

0 Votes 0 ·

Hello @42315514,

You can use .alter ingestion mapping which alters an existing ingestion mapping that is associated with a specific table/database and a specific format (full mapping replace).

For more details, refer to .alter ingestion mapping.

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


0 Votes 0 ·
42315514 avatar image 42315514 PRADEEPCHEEKATLA-MSFT ·

Thanx. It works now. I changed my table ingestion json mapping and now the empty columns are automatically filled.

0 Votes 0 ·
Show more comments