Azure stream analytic input from IoT hub

Question

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.

Answer 1

have a look at the GetMetadataPropertyValue function and examples:

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