Forum Discussion
GouravIN
Apr 07, 2022Brass Contributor
Need help with Custo
Hi All, I have a query that I am running to fetch some data factory logs however the output contains a whole lot of JSON values so can't display them on ALA output console. Hence I am extendi...
Clive_Watson
Apr 07, 2022Bronze Contributor
Take a look at mv-expand and bag unpack
- GouravINApr 07, 2022Brass Contributor
Hi Clive_Watson ,
Thanks for your response.I did try to run the below query after some suggested tweaking however the error that I am getting after running the below query is: -
{"errorMessage":"Value is too large to be parsed for logging"}
The query I am using is as follows: -
ADFActivityRun | where PipelineName == "PL_Ingestion" | where Status == "Succeeded" and OperationName has "Configtablelookup" | extend d = parse_json(Output) | mv-expand d | project d // or I also used todynamic in place of parse_json ADFActivityRun | where PipelineName == "PL_Ingestion" | where Status == "Succeeded" and OperationName has "Configtablelookup" | extend d = todynamic(Output) | mv-expand d | project d