Stream Analytics job does not stream the data to the database

Question

I have a Python script that sends data to the IoT Hub using MQTT. A message routing configuration is set up to route the data to a Blob storage, and this part is working as expected—I can see the data in the storage.

My next goal is to route the data to a database. To achieve this, I created and connected the input, query, and output in Stream Analytics. I also tested the connections and verified the query.

Here is the query I tested:

However, after checking the database, I found it empty. Only one row has been created.

What am I missing here?

Answer 1

Hello @Klajderic Aljosa HSLU I ,

welcome to this moderated Azure community forum.

You connect the Stream Analytics job via the 'eventhub compatible endpoint' of the Azure IoT Hub.

And you added a custom route for the blobs.

By adding that route, you triggered a 'side effect', that eventhub compatible endpoint turns into a fallback route scenario:

The solution is easy:

Just add an extra (second) route for the build-in endpoint and you have your flow back:

Check the text on the message routing about more details.

---

If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.