CODEWITHSUNDEEP
azure-iot-hubazure-data-explorer
Woozar
Woozar

Reputation: 1130

How to import application properties from iot hub message enrichment into azure data explorer

We are using azure iot hub and azure iot edge devices for multiple of our customers. The devices are sending their telemetry data using iot hub telemetry messages. In the iot hub we use message routing -> enrich messages to add the customer id to the messages application properties. This works pretty good if we forward the messages to service bus topics and consume them using azure functions as the application properties are easily accessable there.

Instead of using Azure functions, we now want to store all the telemetry data directly in azure data explorer databases and we want to split the messages to one dedicated database per customer (the name of the database is the customer-id).

So far I could not figure out how to access the application properties from iot hub when importing data to the data explorer? I am not even sure that it is possible, but i really hope it is.

Upvotes: 0

Views: 448

Answers (1)

Avnera
Avnera

Reputation: 7608

Unfortunately automatically routing messages to different databases is not currently supported, please add a request to Azure Data Explorer user voice. For now, you can do the message routing to a dedicated event hub per customer (i.e. per database) and create one Azure Data Explorer data connection per database.

Please note that within a data connection you can dynamically route the messages to different tables by adding the table information to the event properties, see sample here

Upvotes: 2

Related Questions