Is it possible to run an event-based trigger based on a lakehouse?

[arpost]

Greetings, all. I know there is an event-based trigger feature in preview for Fabric pipelines, but it doesn't appear to me that there's any way to tie that to a lakehouse. Does anyone know of a way to get an event-based trigger in place for files uploaded to a lakehouse?

[v-yilong-msft · Accepted solution]

Hi @arpost ,

It seems that run an event-based trigger based on a lakehouse doesn't have this feature yet. It's also not mentioned in the official documentation: Data pipelines storage event triggers in Data Factory (Preview) - Microsoft Fabric | Microsoft Learn

In Azure Data Factory or Azure Synapse Analytics, you can create storage event triggers that respond to events like file uploads in Azure Blob Storage. However, for lakehouses specifically, the support for event-driven triggers might be limited.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Houston-ho]

This is helpful.
One more point for you in case you need some pre-built event from other SaaS aplication, you may consider the power automate connectors becasue there are over 2000 different connectors and each connector has different event trigger, whch provide you much more options. List of all Power Automate connectors | Microsoft Learn

Then use power automate run the data factory pipeline run (only for Azure Data Factory, seems not yet Fabric).

[frithjof_v]

I'm hoping for more native integrations between Fabric and Power Platform.

Consider voting here (see links below) to highlight the need for integrations between Fabric and Power Automate / Power Apps:

Microsoft Fabric Data Factory Connector

https://ideas.powerautomate.com/d365community/idea/66fa7e24-d35f-ef11-a4e7-000d3a7bac27

OneLake Power Automate

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=3b78c053-b342-ee11-a81c-6045bd7cf4ed

Fabric Lakehouse connector (Power Automate)

https://ideas.powerautomate.com/d365community/idea/8bb4e21b-ba3f-ef11-b4ae-000d3a05ba58

Fabric Lakehouse connector (Power Apps)

https://ideas.powerapps.com/d365community/idea/6f09e7a1-226c-ef11-a4e6-6045bd83a7af

PowerApps: Fabric Lakehouse connector

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=7a7b4aa2-216c-ef11-a4e5-6045bdb54c1c

Fabric Warehouse table support for Primary Key enforced

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=e4343298-be0e-ee11-a81c-000d3a0ec312

Power Apps: Fabric Warehouse connector

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=4857bca3-236c-ef11-a4e5-6045bdb54c1c

Fabric Warehouse connector (Power Apps)

https://ideas.powerapps.com/d365community/idea/f5f77a41-246c-ef11-a4e6-6045bd83a7af

Fabric Warehouse connector (Power Automate)

https://ideas.powerautomate.com/d365community/idea/72cf4737-256c-ef11-a4e7-000d3a0eba57