azure data exporer ingestion iot from iot hub not showig system properties

Question

I cannot get message-id from system properties of iothub message. It's not present on the message despite being turned on in connection settings.

I was following this manual https://video2.skills-academy.com/en-us/azure/data-explorer/ingest-data-iot-hub-overview

Answer

Hello @Pavel Nikulin ,

you want to connect an IoT Hub to Azure Data Explorer so you see live data streaming.

Did you check out the mapping?

Check out this example mapping:

.alter table Telemetry ingestion json mapping "JsonMapping"  
    '['  
        '{"Column": "messageId", "Properties": {"Path": "$.messageId"}},'  
        '{"Column": "deviceId", "Properties": {"Path": "$.deviceId"}},'  
        '{"Column": "temperature", "Properties": {"Path": "$.temperature"}},'  
        '{"Column": "humidity", "Properties": {"Path": "$.humidity"}},'  
        '{ "column" : "IotHubDeviceId", "Properties":{"Path":"$.iothub-connection-device-id"}},'  
        '{"Column": "IotHubEnqueuedTime", "Properties": {"Path": "$.iothub-enqueuedtime"}}'  
    ']'

Here, you see how the extra properties are added and mapped to columns.

This is also described in the documentation.

Now, the extra columns are shown:

Share via

azure data exporer ingestion iot from iot hub not showig system properties

1 answer