locked
Microsoft Azure Stream analytics and blob storage input RRS feed

  • Question

  • 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?


    Sunday, September 16, 2018 12:24 PM

All replies

  • Is there any reason why can't you read into Stream Analytics directly from Event Hubs, and them store data into Blob (for future archive) and also power dynamic dashboarding experience in Power BI or Power BI embedded? I would recommend this architecture knowing what I see above. 

    Monday, September 17, 2018 4:36 PM