CODEWITHSUNDEEP
azureazure-stream-analyticsazure-blob-storage
amplifier
amplifier

Reputation: 1833

Microsoft Azure Stream analytics and blob storage input

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?

Upvotes: 1

Views: 1458

Answers (1)

Jay Gong
Jay Gong

Reputation: 23792

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

Upvotes: 0

Related Questions