Multiple messages when new item created

[jmeisenh]

I am attempting to create an alert when a new table is added to a lakehouse. I have created an eventstream from OneLake events, NewFileCreated and added an alert to send a Teams message when the event triggers, however we are receiving 6-20 messages per event. I am assuming this is creating an individual alert for each parquet file. Is there a way to only tirgger a single alert for each table?

[v-achippa]

Hi @jmeisenh,

Thank you for reaching out to Microsoft Fabric Community.

In Fabric, creating a new table generates multiple file creation events, so multiple alerts are expected if you directly use NewFileCreated from OneLake. Currently there is no built in way to get a single alert per logical table created from OneLake.

The best approach is to use sliding window aggregation in your Eventstream, grouping events by the table path and a short time window for example like 1 minute window. This ensures that only one alert is triggered per table, no matter how many files are created.

This is the best method for triggering one alert per table in Fabric.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa