Forum Discussion
Create eventstream from Lakehouse to Activator
Hi,
We have a data lakehouse and would like to use that data to create a trigger. So for example, we have a table with transaction data. Everytime a new row is added where the transaction value is greater than 10,000 I would like to trigger a message. I think the right approach should be retrieving the data from my lakehouse via an eventstream to an activator but this does not work for me. I can't find any way on how to load the data properly to the eventstream and thus also not via the eventstream to Activator. Also directly in activator did not seem to work for me.
I used external source -> OneLake events and then I connected to my lakehouse. See attached screenshot:
Hi all,
For those wondering, I found this article of Dennes that described how to connect your lakehouse to an eventhouse and after that use data activator from the eventhouse. Here is the article: https://www.red-gate.com/simple-talk/blogs/microsoft-fabric-using-lakehouse-data-in-real-time-dashboards/
6 Replies
Hi bramvdbemt ,
The OneLake events in external source is not used by eventstream to detect data, it is used to detect if behaviors such as creating, deleting, modifying Fabric artifacts, etc., for example, creating, deleting dataflow, etc., have occurred in your OneLake.
If you need to use eventstream to connect to data in your Lakehouse, you need to make sure that transactional data in your lakehouse can be read and monitored, and that updates from the lakehouse are pushed to the Event Hub.This requires you to set up an Event Hub to receive new data from lakehouse.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi all,
For those wondering, I found this article of Dennes that described how to connect your lakehouse to an eventhouse and after that use data activator from the eventhouse. Here is the article: https://www.red-gate.com/simple-talk/blogs/microsoft-fabric-using-lakehouse-data-in-real-time-dashboards/
Hi Dino,
By Event Hub, do you mean an Eventhouse in Fabric?
Best regards,
Bram van den Bemt
Hi bramvdbemt ,
No. I mean the Event Hubs in the Microsoft Azure:
Azure Event Hubs documentation | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
