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
GouravIN
Apr 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