How can we improve Microsoft Azure Stream Analytics?

Support IoTHub.* in Azure Stream Analytics Tools for Visual Studio

When authoring a query in the portal, I use the IoTHub object to get at items like IoTHub.EnqueuedTime (discussed here: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-define-inputs#stream-data-from-iot-hub) These do not work in the ASA tools for Visual Studio.

When you use stream data from an IoT Hub, you have access to the following metadata fields in your Stream Analytics query:
Property
Description
EventProcessedUtcTime
The date and time that the event was processed.
EventEnqueuedUtcTime
The date and time that the event was received by the IoT Hub.
PartitionId
The zero-based partition ID for the input adapter.
IoTHub.MessageId
An ID that's used to correlate two-way communication in IoT Hub.
IoTHub.CorrelationId
An ID that's used in message responses and feedback in IoT Hub.
IoTHub.ConnectionDeviceId
The authentication ID used to send this message. This value is stamped on servicebound messages by the IoT Hub.
IoTHub.ConnectionDeviceGenerationId
The generation ID of the authenticated device that was used to send this message. This value is stamped on servicebound messages by the IoT Hub.
IoTHub.EnqueuedTime
The time when the message was received by the IoT Hub.

1 vote
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Kevin Saye shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • joe zhang commented  ·   ·  Flag as inappropriate

    Hi Kevin,

    could you describe your issue in more detail ? What cannot work in ASA VS tools and what you mean for "use the IoTHub object to get at items like IoTHub.EnqueuedTime in portal ". That will be better you can show us expected behavior.

Feedback and Knowledge Base