CODEWITHSUNDEEP
azureazure-eventhubdata-ingestionazure-data-explorer
Neeraj
Neeraj

Reputation: 168

Data from event hub not getting populated in ADX database

I created a sample application to send events to the event hub, which subsequently sends data to the azure data explorer database. I can see the events appearing in the event hub, but the same is not getting ingested in the Azure Data Explorer database even after creating the data ingestion from the event hub.

I have already deleted and recreated the data explorer and along with the database and data ingestion from the event hub, but no success. BTW, I have also done metadata mapping.

The data should be inserted to the ADX database table, and I should be able to query the data, but the query to the table returns a blank.

Upvotes: 5

Views: 2569

Answers (3)

Sampath Kumar K
Sampath Kumar K

Reputation: 61

For me Multiline JSON has turned out to be the issue. Using Multiline JSON as the data format has fixed the issue for me.

Upvotes: 1

Neeraj
Neeraj

Reputation: 168

Thanks, Yoni for providing the command to debug. It helped in debugging. I finally found the solution by changing the type of table from JSON to MultiJSON as the data included nested JSON data.

If your JSON does not contain nested/multiline JSON, you can choose simple JSON, else for multiline JSON, choose MultiJSON

Upvotes: 3

Yoni L.
Yoni L.

Reputation: 25905

a few data points which may be helpful in troubleshooting this:

  1. does .show ingestion failures run against your ADX cluster show anything related?

  2. how does your ingestion mapping look like, and how does a sample event look like?

Upvotes: 2

Related Questions