11-10-2021 02:32 AM
Hi, this seems like a really basic feature to have, an alert is generated and spits out the email, but the URL doesn't take you to the events list that happened at that time but just the query in the editor (via the alert config screen). We're really struggling to make use out of this feature with no persisted history and no way seemingly to format the alert in to a table of results. Please can I request the persisting of historic alert events as a feature request or can someone let me know if im just not seeing it? Thank you
11-10-2021 10:50 AM
@Nick Hughes I was looking at our ideas portal and could see an API feature was requested for the Alerts (DB-I-4289). To create an API for the alerts and pull data, we might need to keep the alert history persistent. So this feature should suffice your requirement.
You can refer to the below post:
https://community.databricks.com/s/question/0D53f00001SAWH5CAP/is-there-an-alerting-api-please
11-10-2021 02:35 AM
Hi @Nick Hughes , for the feature request you can raise it in our ideas portal so that it will have direct visibility to the product team and develop in the future.
11-10-2021 02:57 AM
@Prabakar Ammeappin does this mean it's definitely not a current feature and history is lost?
11-10-2021 02:59 AM
You mean alerts for jobs runs?
If yes you can write own script to handle that as API for jobs have information related to alerts like timeout or status failed https://docs.databricks.com/dev-tools/api/latest/jobs.html#operation/JobsRunsList
On Azure when you run databricks notebooks via Data Factory it have really nice feature to manage failure state and you can create own alerts (via Logic Apps)
11-10-2021 03:09 AM
Hiya,
No, not for job runs, for the business alerting feature off scheduled queries
11-10-2021 03:22 AM
@Nick Hughes Do you mean the dbsql queries and alerts?
11-10-2021 03:33 AM
This one @Prabakar Ammeappin -https://docs.databricks.com/sql/user/alerts/index.html
11-10-2021 03:53 AM
aaa now I get it. The best option would be that Databricks add SQL alerts history to SQL API https://docs.databricks.com/sql/api/index.html
11-10-2021 05:04 AM
@Nick Hughes For Alerts, I don't think we have a persistent history. The SQL API mentioned by @Hubert Dudek works for the SQL query history like status, time range, endpoint, user id. But it won't give you the history of the alerts that you set. So for the SQL alert history, I would suggest you raise a feature request.
https://docs.databricks.com/sql/api/query-history.html#queryfilter
11-10-2021 10:50 AM
@Nick Hughes I was looking at our ideas portal and could see an API feature was requested for the Alerts (DB-I-4289). To create an API for the alerts and pull data, we might need to keep the alert history persistent. So this feature should suffice your requirement.
You can refer to the below post:
https://community.databricks.com/s/question/0D53f00001SAWH5CAP/is-there-an-alerting-api-please
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.
If there isn’t a group near you, start one and help create a community that brings people together.
Request a New Group