Azure Steam Analytics Query
I want to store the below JSON data to the Azure table. Here the input and the output for Azure Stream Analytics are Azure IoT Hub and table respectively. [ { "device1": [ { "name": "temperature", "value": 50 }, "name":…
Azure Stream Analytics reports watermark delay
Azure Stream Analytics is used to distribute JSON data incoming from azure IoT hub into tables of SQL database. Recently there were several large watermark delays which totally ruined the pipeline. When it works normally it has a delay of…
Azure – Load JSON to SQL database tables
I have JSON files that at the end of the day should be inserted to SQL Database. To explain what I mean, let's assume the JSON looks like this:{ name : "John", surname : "Smith", movie: "Snatch" } And database…