Event Trigger to execute pipeline when a new file is created inside Lakehouse

[abhiram342]

Hi,

We want to create an Event based trigger to run Data Pipeline whenever a new file is created inside Lakehouse.

Please let us know how to achieve it. I tried with storage account trigger and it works fine but I don't want to create seperate storage account for this scenario, instead want to leverage existing lakehouse .

Thanks,

Abhiram

[Anonymous]

Hi @abhiram342 ,

Is my follow-up just to ask if the problem has been solved?

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

Thank you very much for your cooperation!

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

Hi @abhiram342 ,

Thanks to FabianSchut for the solution.

Were the above suggestions helpful in your situation? If this is the case, you may want to consider Accept is helpful suggestions to help others facing similar requirements.

Thank you very much for your cooperation!

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous · Accepted solution]

Hi @abhiram342 ,

In the Fabric Data Factory Pipeline Design canvas, there is a Triggers button that allows you to create Reflex triggers for the pipeline, or you can create triggers directly from Data Activator.

It's still in preview, but I think it does what you want.

For more information, please refer to:

Data pipelines storage event triggers in Data Factory (Preview) - Microsoft Fabric | Microsoft Learn

Re: Event based trigger to run Data Pipeline when ... - Microsoft Fabric Community

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[FabianSchut]

Unfortunately, The data activator (advanced pipeline trigger) is not working for a lakehouse yet. Here is a workaround someone posted: https://community.fabric.microsoft.com/t5/Data-Warehouse/Onelake-trigger-to-Ingest-CSV/m-p/4120366