9. Stream Analytics
? 寄楚のデ`タをリアルタイムにI尖するクエリエンジン
9
Azure
Stream
Analytics
SELECT
System.Timestamp as Time,
DeviceId,
CAST(AVG(frompis.Temp) AS float) AS Temp,
CAST(AVG(frompis.Pressure) AS float) AS Pressure,
CAST(AVG(frompis.Hum) AS float) AS Hum,
CAST(AVG(frompis.HiLux) AS float) AS HiLux,
CAST(AVG(frompis.LowLux) AS float) AS LowLux
INTO
powerbi
FROM
raspisensors TIMESTAMP BY Date
GROUP BY
DeviceId,
TumblingWindow(second, 30)
SQL Database
Storage
Document DB
Event Hub
Power BI