Extract part of string from row

user_19751914 0
Viewed 43

I am trying to run a kusto query and I need to extract offerThroughput from the row, please if you can advice. Thanks.

Sample data

"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}}"
kql azure-data-explorer
1 Answers
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 *
activityId_g resourceDetails_s offerThroughput
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}} 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,offerIsAutoScaleEnabled:false}} 8000

Fiddle

user_63364790
Related