azure - 在数据库中创建物化 View 后如何检查其回填属性？

Question

我已经在 ADX 中创建了带有回填属性集的物化 View 。如果我必须在创建后检查回填属性，如何使用 kusto 命令检查它。示例:

    .create async ifnotexists materialized-view with (**backfill=true, docString="Asset Trends",effectiveDateTime=datetime(2022-06-08)**) AssetTrend on table Variables {
Variables | summarize Normal = countif(value<=1), CheckSUM = countif(value>1 and value<=250), OutofSpecification = countif(value>250 and value<=500), MaintenanceRequired = countif(value>500 and value<=750), Failure = countif(value>750 and value<=1000) by bin(timestamp,1s)  , model, objectId, tenantId, variable }

Answer 1

更新(根据 Yifat 的评论):

.show materialized-view MyMV
    | project EffectiveDateTime

<表类=“s-表”><标题>有效日期时间 <正文>2022-08-29T11:25:48.2667521Z

---

搜索相关ClientActivityId然后运行这个:

.show commands 
| where ClientActivityId == ...
| project ResourcesUtilization.ScannedExtentsStatistics
| evaluate bag_unpack(ResourcesUtilization_ScannedExtentsStatistics)  
| distinct *    

<表类=“s-表”><标题>最大数据扫描时间MinDataScannedTimeScannedExtentsCount扫描行数TotalExtentsCount总行数 <正文>2022-08-29T11:25:52.0952791Z2022-08-29T11:25:48.2667522Z81200000008120000000

以下是 MV 所依据的表格中的信息:

.show table r100k details 
| project TotalExtents, TotalRowCount, MinExtentsCreationTime, MaxExtentsCreationTime

<表类=“s-表”><标题>总范围总行数MinExtentsCreationTimeMaxExtentsCreationTime <正文>81200000002022-08-29T11:25:48.2667522Z2022-08-29T11:25:52.0952791Z