Skip to content

Instantly share code, notes, and snippets.

@brijrajsingh
Created October 14, 2019 10:52
Show Gist options
  • Save brijrajsingh/87a9fdb8d9641be13b7405e23a85ae1d to your computer and use it in GitHub Desktop.
Save brijrajsingh/87a9fdb8d9641be13b7405e23a85ae1d to your computer and use it in GitHub Desktop.
ADF Counts Query
ADFActivityRun
| project Output, PipelineRunId,Status,OperationName
| where PipelineRunId == "YourPipelineRunId"and Status == "Succeeded"and OperationName startswith"Copy"
| extend dataRead_ = todouble(parse_json(Output).dataRead), filesWritten_ = todouble(parse_json(Output).filesWritten)
| summarize TotalDataReadGB=sum(dataRead_)/1000/1000/1000, TotalFilesWrittenInMils=sum(filesWritten_)/1000000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment