I have a stream from IoT Hub like: I want to pass this stream in a SQL DB like this: is there any way to use cross apply or other way to create two new columns form multi json element Answer If it’s a static pivot (you know in advance the list of fields and you can hardcode their value),
Tag: azure-stream-analytics
Azure Stream Analytics Job delayed output of not matching records by 1 minutes between two event hubs
Could anyone help me, why the not matching records are delayed by exactly 1 minutes but the matching records are writing into blog storage container immediately. Is there any way to avoid the delay even though eventA its not matching with other eventB (being my downstream system will take care in my use-case) Below is the output but look at