How to build a framework for creating Data Activators in Fabric?

[traneddy2]

Hello Mr./Ms.,

I have studied Data Activator in Fabric and noticed that we can create alerts based on rules through the UI. I would like to ask if there is a way to build a framework that can create Data Activators on the fly based on a metadata table containing the rules for specific tables. This way, we can use Data Activator more dynamically.

Thank you.

[v-echaithra]

Hi @traneddy2 ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-echaithra]

Hi @traneddy2 ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

[v-echaithra]

Hi @traneddy2 ,

Thank you @svelde  for your inputs.

I hope the information provided is helpful. I wanted to check whether you were able to resolve the issue with the provided solutions. Please let us know if you need any further assistance.

Thank you.

[svelde]

Hello @Eddy Tran,

welcome to this moderated Azure community forum.

The functionality you describe is not there in Fabric Activator.

If you want to be more flexible, you need to be more creativg (with eg. Eventstream together with the SQL transformation of a pipeline).

If you want full control, you need to rely on Azure PaaS solutions, the underlying technology used by Fabric. Think of a combination of Azure Stream Analytics, EventHubs, Azure Functions, and Logic Apps.

A hybrid approach with Azure PaaS and Fabric could help you this way.

You can always post your idea here

[traneddy2]

Hello @kustortininja ,

Do we have some specific documents for this?

Thanks.

[kustortininja]

Do you mean for what I suggested? No, sorry, I don't see any documentation that walks through step by step how to do this. Although it is a great idea and would be a great blog article!

[v-echaithra]

Hi @traneddy2 ,

Please refer to these documents for creating data activators in Fabric.
What is Fabric Activator? - Microsoft Fabric | Microsoft Learn
Activator tutorial using sample data - Microsoft Fabric | Microsoft Learn

Best Regards,
Chaithra E.

[kustortininja · Accepted solution]

Hello @traneddy2 , yes this could be doable. There would be a few caveats and considerations. The underlying data that you would want to create the rule on would need to be one through one of the supported activator sources. (Eventhouse, Power BI, etc.), but here's how you could make it work:

Create some data store that you use to power your rules (Excel, SQL, Eventhouse, etc.)
You need to include the required fields as a part of the Activator Create Rule API definition set. 

Create a script to iterate over the rules, calling the API for each rule definition that you want to create. 

You need some mechanism to allow the Activator to update the table where you stored the metadata to be updated and indicate that it has already been created. Otherwise, nothing would stop the script from recreating the Activator every time the script runs, as Activator does not have any logic or rules to prevent rule duplication.