Stream Analytics and Power BI

connorcheng

已于 2024-07-05 10:45:15 修改

阅读量269

点赞数 2

分类专栏： Data Engineer 文章标签： azure

于 2024-07-04 14:43:31 首次发布

本文链接：https://blog.youkuaiyun.com/weixin_44504151/article/details/140178147

版权

Data Engineer 专栏收录该内容

16 篇文章

订阅专栏

rm -r dp-203 -f

git clone https://github.com/MicrosoftLearning/dp-203-azure-data-engineer dp-203

cd dp-203/Allfiles/labs/19

./setup.ps1

SELECT
     DateAdd(second,-5,System.TimeStamp) AS StartTime,
     System.TimeStamp AS EndTime,
     ProductID,
     SUM(Quantity) AS Orders
 INTO
     [powerbi-dataset]
 FROM
     [orders] TIMESTAMP BY EventEnqueuedUtcTime
 GROUP BY ProductID, TumblingWindow(second, 5)
 HAVING COUNT(*) > 1