Microsoft Azure Stream analytics and blob storage input

1
votes

I have a blob storage where I store data from event hub using routes. I want to display that data, for example in PowerBI, or put it in a topic etc.

For that I create a stream analytics job. I set "Blob storage" as an input, and one of my topics as an output.

I wrote a very basic SQL

SELECT
    * INTO
    [sajoutputtopic] FROM
    [blobstoragesajinput]

Then I send message to IoT Hub: {"deviceId":"mydevice","messageId":921,"temperature":31,"humidity":72}

In azure I can see that is stored in blob Then I test the SQL:

  1. download blob
  2. right click on the input -> "upload sample data from file", select "AVRO"

but when I click test, I get 0 rows.

What am I doing wrong?

1
azureazure-stream-analyticsazure-blob-storage
Sorry but I dont understand what is the problem: the data are not in blob storage or you cant access it from stream analitycs ? – Thomas
@Thomas the data is in blob storage, but I can't get and push to stream analytics output (SELECT always returns 0 rows) – amplifier

1 Answers

0
votes

amplifier. You need to check the file format you downloaded. It need to be matched with the selected option. I created json file which stores your sample data. Then I right clicked on the input -> "upload sample data from file", select "JSON". It works fine.

enter image description here