AZ3166 IoT Hub Table Mapping

Jonathan GOH 46 Reputation points
2022-03-14T07:43:55.09+00:00

Hi, recently I have been trying to ingest data from IoT Hub to Data Explorer along with the MXChip AZ3166. However, I am unable to map the enqueued time onto the Data Explorer table, whereas the other variables are mapped just fine. I've inserted my code and screenshots to help me describe the issue. May I know what the issue might be? Thank you

.create table TelemetryIoTHub (EnqueuedTime: datetime, Temperature: real, Humidity: real, Pressure: real, GyroX: real, GyroY: real, GyroZ: real, AccelX: real, AccelY: real, AccelZ: real, MagX: real, MagY: real, MagZ: real)   

.create table TelemetryIoTHub ingestion json mapping 'DataMapping'   
'[{"column":"EnqueuedTime","path":"$.enqueuedTime","datatype":"datetime"},{"column":"Humidity","path":"$.humidity","datatype":"real"},{"column":"Pressure","path":"$.pressure","datatype":"real"},{"column":"Temperature","path":"$.temperature","datatype":"real"},{"column":"AccelX","path":"$.accelX","datatype":"real"},{"column":"AccelY","path":"$.accelY","datatype":"real"},{"column":"AccelZ","path":"$.accelZ","datatype":"real"},{"column":"GyroX","path":"$.gyroX","datatype":"real"},{"column":"GyroY","path":"$.gyroY","datatype":"real"},{"column":"GyroZ","path":"$.gyroZ","datatype":"real"},{"column":"MagX","path":"$.magnetX","datatype":"real"},{"column":"MagY","path":"$.magnetY","datatype":"real"},{"column":"MagZ","path":"$.magnetZ","datatype":"real"}]'  

182638-screenshot-2022-03-14-153528.png

182751-screenshot-2022-03-14-153850.png

Azure IoT
Azure IoT
A category of Azure services for internet of things devices.
401 questions
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,201 questions
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.
531 questions
{count} votes

1 answer

Sort by: Most helpful
  1. QuantumCache 20,271 Reputation points
    2022-03-14T22:31:48.15+00:00

    Hello @Jonathan GOH When you expand the row, do you see the payload property empty ?

    183062-image.png

    Please try making use of string data Type for he table creation.

    183054-image.png

    Also please refer to Scalar data types

    Please comment in the below section for further help in this matter, happy to help!

    Please accept the helpful response as 'Answer', which will be helpful to others as well with similar questions


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.