Stream Analytics job does not stream the data to the database

Question

Stream Analytics job does not stream the data to the database

Klajderic Aljosa HSLU I 55

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.

User's image

Here is the query I tested:

User's image

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

User's image

What am I missing here?

Sampath 3,880 Reputation points Microsoft External Staff Moderator

2025-02-03T03:19:18.76+00:00

@Klajderic Aljosa HSLU I Just checking in to see if the provided answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further queries do let us know.
Sampath 3,880 Reputation points Microsoft External Staff Moderator

2025-02-04T03:03:20.7033333+00:00

@Klajderic Aljosa HSLU I, We still have not heard back from you.

Just wanted to check if the answer provided below was helpful? If it answers your query, please do click Accept Answer and Yes for the answer, as it might be beneficial to other community members reading this thread.

And, if you have any further query do let us know.

Answer accepted by question author

1 additional answer

Your answer

Sampath 3,880 Reputation points Microsoft External Staff Moderator

2025-02-03T03:19:18.76+00:00

@Klajderic Aljosa HSLU I Just checking in to see if the provided answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further queries do let us know.
Sampath 3,880 Reputation points Microsoft External Staff Moderator

2025-02-04T03:03:20.7033333+00:00

@Klajderic Aljosa HSLU I, We still have not heard back from you.

Just wanted to check if the answer provided below was helpful? If it answers your query, please do click Accept Answer and Yes for the answer, as it might be beneficial to other community members reading this thread.

And, if you have any further query do let us know.

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:

User's image

The solution is easy:

User's image

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

User's image

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.

Answer 2

Klajderic Aljosa HSLU I 55

Hi,

sorry for the late reply and thanks for the help!

Share via

Stream Analytics job does not stream the data to the database

1 additional answer

Your answer