Azure stream analytic input from IoT hub

Navid Ahrary 21 Reputation points
2020-08-15T05:06:18.277+00:00

I have a iot solution with iot hub and sql db . so I use stream analytics that integrated in sql db.
The problem is:
The Input came from iot hub's event endpoint and enriched with iot hub's message enrichment feature.
In stream analytic I could get telemetry but i could'nt get the application properties. Is this possible?
For test I could get telemetry with application properties with event hub sdk but I have problem in Stream analytics.

Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,189 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
354 questions
0 comments
Accepted answer
  1. Roman Kiss 2,246 Reputation points
    2020-08-15T05:28:30.383+00:00

    have a look at the GetMetadataPropertyValue function and examples:

    SELECT Name, GetMetadataPropertyValue(iotInput, '[User].[SenderClientId]') FROM iotInput

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.