Alerts for Failed Queries in Databricks

[AcrobaticMonkey]

How can we set up automated alerts to notify us when queries executed by a specific service principal fail in Databricks?

[Alberto_Umana]

Hi @AcrobaticMonkey,

How are you triggering the queries using a service principal, is it through a workflow job? If so then you can use Job notifications.

I would need more details but one possible solution is to implement Alerts:

https://docs.databricks.com/en/sql/user/alerts/index.html

[AcrobaticMonkey]

@Alberto_UmanaOur service principal uses the SQL Statement API to execute queries. We want to receive notifications for each query failure. While SQL Alerts are an option, they do not provide immediate responses. Is there a better solution to achieve near-real-time failure notifications?