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.
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