Mirror Database Update event

[DiKi-I]

Hi ,
I want to trigger events based on data updated in mirror db. The mirror db is azure sql db. Is it possible to trigger pipelines/notebook as soon as data updates in mirrored db in fabric?

[v-ssriganesh]

Hello @DiKi-I,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

[v-ssriganesh]

Hello @DiKi-I,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[v-ssriganesh]

Hi @DiKi-I,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @tayloramy  for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[tayloramy · Accepted solution]

Hi @DiKi-I, 

Mirrored databases should be stored as Delta files in OneLake. 

You should be able to use Activator to create a OneLake event trigger to watch for those files being created. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution.

[DiKi-I]

how the mirrored db file is stored in one lake do you have any detail? I'm using using azure sql and then mirror

ing in microsoft fabric/

[tayloramy]

Hi @DiKi-I, 

You should be able to do this with an event-driven pattern: when mirroring writes changes into OneLake as Delta files, you trigger a pipeline as soon as new files land. Microsoft confirms that mirrored data is stored as Delta Parquet in OneLake (Mirroring overview, What is Mirroring in Fabric?). Fabric Data Factory supports event triggers on file arrival in OneLake (Data pipelines event triggers; see also the tutorial that sets up a pipeline that runs when a new file lands in OneLake: Build event-driven data pipelines).

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution.