Microsoft Azure流分析和Blob存储输入 [英] 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.

为此，我创建了一个流分析作业.我将"Blob存储"设置为作为输入，而我的主题之一作为输出.

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

我写了一个非常基本的SQL

I wrote a very basic SQL

SELECT
    * INTO
    [sajoutputtopic] FROM
    [blobstoragesajinput]

然后将消息发送到IoT中心:

天蓝色时，我可以看到它存储在blob中，然后测试SQL:

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

1. 右键单击输入-> 从文件上传示例数据"，选择"AVRO"

，但是当我单击测试时，我得到了0行.

but when I click test, I get 0 rows.

我在做什么错了?

推荐答案

您是否有任何原因不能直接从Event Hubs读取Stream Analytics，并将它们存储到Blob(以供将来存档)中，并不能在Power BI或Power BI Embedded中提供强大的动态仪表板体验?我会推荐这种架构 知道我在上面看到的内容. 

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. 

这篇关于Microsoft Azure流分析和Blob存储输入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！