MULTIJSON data format missing when creating a Data Explorer data connection in the Azure Portal

J-C 0 Reputation points
2023-11-01T20:42:29.5433333+00:00

When creating a data connection from ADX/Kusto to EventHub, I would like to choose the MULTIJSON data format. If I recall correctly, this option was available in the Azure Portal, but there is only the JSON format now (see screenshot).

The docs still mention that data format, and I couldn't find any mention of it being deprecated. It is still possible to set it with Terraform, and I confirmed that it is working (we had data ingestion failures with JSON that stopped when we switched to MULTIJSON).

Is the MULTIJSON data format being phased out? Is this is a bug in the Azure Portal?

Ref:
https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/kusto_eventhub_data_connection#data_format
https://learn.microsoft.com/en-us/azure/data-explorer/ingest-json-formats?tabs=kusto-query-language#the-json-format

User's image

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
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
579 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Sander van de Velde 30,321 Reputation points MVP
    2023-11-01T21:52:53.21+00:00

    Hello @J-C ,

    welcome to this moderated Azure community forum.

    Yes, I can confirm this Multi-line-JSON was part of the selection in the past:

    User's image

    It is missing (although still referenced in the documentation) for both EventHub and IoTHub ingestion.

    It's unclear why this is not available in the portal anymore.

    Luckily, it still works for you using terraform. The same goes for the SDK.

    I will try to contact someone from the team to confirm this caveat.


    If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.