Diagnostics workflow events as Synapse pipeline triggers

(1) Share

Report

Posted on by DavidBest

We currently export our Customer Insights diagnostics to ADLS gen2 storage account. They are stored but not formatted in such a way as to be used for for anything but laborious one-off querying.

The use case we are trying to achieve to is use Workflow events operationName 'export' with resultType 'success' as a trigger to start a pipeline in Synapse analytics.

Does anyone have any experience with achieving a similar result? Or does anyone have any experience with building out and formatting the diagnostics data in ADLS in useful ways?

Interested to hear what experience the community might have.

FYI I have also raised a support case with Microsoft to explore further. Please note that I am familiar with the documentation here - https://learn.microsoft.com/en-us/dynamics365/customer-insights/data/diagnostics#workflow-event-schema.

What I am looking for is real world uses and experience to help guide the team in discovery before we start Dev.

Thank you