Query for getting logs for Azure Machine Learning pipeline runs

%3CLINGO-SUB%20id%3D%22lingo-sub-1893346%22%20slang%3D%22en-US%22%3EQuery%20for%20getting%20logs%20for%20Azure%20Machine%20Learning%20pipeline%20runs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1893346%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3E%3CSPAN%3EWhat's%20the%20KQL%20query%20for%20getting%20the%20logs%20for%20an%20AML%20Pipeline%20run%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%3CDIV%3E%26nbsp%3B%3CDIV%3E%3CSPAN%3E%3CSPAN%3EI%20could%20only%20find%20a%20sample%20query%20for%20ADF%20pipelines%20as%20follows%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-sql%22%3E%3CCODE%3E%2F%2F%20Pipeline%20runs%20latest%20Status%0A%2F%2F%20Returns%20latest%20Status%20of%20pipeline%20runs.%0AADFPipelineRun%0A%7C%20summarize%20argmax(TimeGenerated%2C%20*%20)%20by%20RunId%2C%20Status%2C%20_ResourceId%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1894344%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20for%20getting%20logs%20for%20Azure%20Machine%20Learning%20pipeline%20runs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1894344%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F871243%22%20target%3D%22_blank%22%3E%40MoOloomi%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOnce%20you%20configure%20the%20logs%20to%20be%20registered%20in%20a%20log%20analytics%20workspace%2C%20if%20you%20click%20%22Logs%22%20option%20on%20the%20workspace%20you%20may%20see%20the%20table%20listed%20among%20the%20existing%20tables%20in%20the%20workspace.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20try%20also%20the%20Kusto%20Explorer%2C%20but%20I%20haven't%20checked%20if%20it%20connects%20to%20Log%20Analytics%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-explorer%2Fkusto%2Ftools%2Fkusto-explorer%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-explorer%2Fkusto%2Ftools%2Fkusto-explorer%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20Regards%2C%3CBR%20%2F%3E%3CBR%20%2F%3EDennes%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
What's the KQL query for getting the logs for an AML Pipeline run?
 
I could only find a sample query for ADF pipelines as follows:

 

// Pipeline runs latest Status
// Returns latest Status of pipeline runs.
ADFPipelineRun
| summarize argmax(TimeGenerated, * ) by RunId, Status, _ResourceId

 

1 Reply

@MoOloomi  

 

Once you configure the logs to be registered in a log analytics workspace, if you click "Logs" option on the workspace you may see the table listed among the existing tables in the workspace.

 

You can try also the Kusto Explorer, but I haven't checked if it connects to Log Analytics:

https://docs.microsoft.com/en-us/azure/data-explorer/kusto/tools/kusto-explorer 

Kind Regards,

Dennes