Azure Digital Twin Alerts and alert notification

Question

I am wanting to use telemetry ingestion through streaming analytics, I need to monitor events/alerts based on a already established set of functionalities. Create a place to put alerts in digital twins. and to store historic events.

Approach is to basically take telemetry from digital twins and filter for events/functionalities through and event grid (currently already doing) ingest through streaming analytics and set up a SQL DB ping sql to pull events for alerts.

Alerts are stuff like rain, temperature, humidity so on and so fourth.

any trailblazers that have better options or even a baseline sql code I could go off of to tinker around with?

Thanks for the help in advance!

Answer 1

@sgt snuffles Welcome to Microsoft Q&A!

Alerts are stuff like rain, temperature, humidity so on and so fourth.

Are you looking for alerts when the telemetry changes?

Azure SQL doesn't offer any events for data updates. You need to query or poll the tables at regular intervals using a Logic app or Azure Function app.

Please see Integrate with Logic Apps using a custom connector for more details.

Different events in Azure Digital Twins produce notifications, which allow the solution backend to be aware when different actions are happening. These notifications are then routed to different locations inside and outside of Azure Digital Twins that can use this information to take action.

There are several types of notifications that can be generated, and notification messages may look different depending on which type of event generated them.

I would suggest you, go through Event notifications documentation for different available types of notifications and configure alerts on ADT.

Please let us know if that helps or have any further queries.

If an answer is helpful, please click on or upvote which might help other community members reading this thread.