从行中提取字符串的一部分



我正在尝试运行kusto查询,我需要从行中提取offerThroughput,如果可以的话,请提供建议。谢谢

样本数据

"activityId_g","resourceDetails_s"
"dfcab056-2561-448a-9585-9bea6888e5ae","{id:H5Nd,_rid:H5Nd,_self:offers/H5Nd/,_ts:1657306008,_etag:0000ab18-0000-0300-0000-62c87b980000,offerVersion:V2,resource:dbs/sDVGAA==/colls/sDVGAKOxPdU=/,offerType:,offerResourceId:sDVGAKOxPdU=,content:{offerThroughput:1000,offerIsRUPerMinuteThroughputEnabled:false,offerIsAutoScaleEnabled:false}}"
"45c05db0-d503-42c3-be77-6a10c8fe7a68","{id:lEVo,_rid:lEVo,_self:offers/lEVo/,_ts:1659477250,_etag:00007500-0000-0300-0000-62e99d020000,offerVersion:V2,resource:dbs/sDVGAA==/colls/sDVGAK1hgXE=/,offerType:,offerResourceId:sDVGAK1hgXE=,content:{offerThroughput:8000,offerIsRUPerMinuteThroughputEnabled:false,offerIsAutoScaleEnabled:false}}"
datatable(activityId_g:guid, resourceDetails_s:string)
[
"dfcab056-2561-448a-9585-9bea6888e5ae","{id:H5Nd,_rid:H5Nd,_self:offers/H5Nd/,_ts:1657306008,_etag:0000ab18-0000-0300-0000-62c87b980000,offerVersion:V2,resource:dbs/sDVGAA==/colls/sDVGAKOxPdU=/,offerType:,offerResourceId:sDVGAKOxPdU=,content:{offerThroughput:1000,offerIsRUPerMinuteThroughputEnabled:false,offerIsAutoScaleEnabled:false}}"
,"45c05db0-d503-42c3-be77-6a10c8fe7a68","{id:lEVo,_rid:lEVo,_self:offers/lEVo/,_ts:1659477250,_etag:00007500-0000-0300-0000-62e99d020000,offerVersion:V2,resource:dbs/sDVGAA==/colls/sDVGAK1hgXE=/,offerType:,offerResourceId:sDVGAK1hgXE=,content:{offerThroughput:8000,offerIsRUPerMinuteThroughputEnabled:false,offerIsAutoScaleEnabled:false}}"
]
| parse resourceDetails_s with * "offerThroughput:" offerThroughput:int *
offerThroughput
activityId_gresourceDetails_s
dfcab056-2561-448a-9585-9bea6888e5ae{id:H5Nd,_rid:H5恩德,_self:offers/H5Nd/,_ts:1657306008,_etag:0000ab18-0000-0300-0000-62c87b980000,offerVersion:V2,resource:dbs/sDVGAA=/colls/sDVAKOxPdU=/,offerType:,offerResourceId:sDVGAKOxPdU=,content:{offerThroughput:1000,offerIsRUPerMinuteThroughputEnabled:false,offer IsAutoScaleEnabled:false}}1000
45c05db0-d503-42c3-be77-6a10c8fe7a68{id:lEVo,_rid:lEVo,_self:offers/lEVo/,_ts:1659477250,_etag:00007500-0000-0300-0000-62e99d020000,offerVersion:V2,resource:dbs/sDVGAA=/colls/sDVGAK1hgXE=/,offerType:,offerResourceId:sDVGAK1hgXE=,content:{offerThroughput:8000,offerIsRUPerMinuteThroughputEnabled:false,offerISAutoScale已启用:false}}8000

最新更新