Databricks Alerts

NLearn — Mon, 02 Sep 2024 10:31:41 GMT

Hello everyone, I have a requirement to set databricks alerts. I am struggling with email body template. I was trying to create button using custom template in html but it did not work out. Is there any sample template for alerts which can show in best format.

Re: Databricks Alerts

szymon_dybczak — Mon, 02 Sep 2024 11:55:14 GMT

Hi @NLearn ,

It should looks like this:

<table> <tr><th>column1 header</th><th>column2 header</th></tr> {{#QUERY_RESULT_ROWS}} <tr> <td>{{column1}}</td> <td>{{column2}}</td> </tr> {{/QUERY_RESULT_ROWS}} </table>

If you're going to use custom template then you can use following built-in template variables:

ALERT_STATUS: The evaluated alert status (string).
ALERT_CONDITION: The alert condition operator (string).
ALERT_THRESHOLD: The alert threshold (string or number).
ALERT_COLUMN: The alert column name (string).
ALERT_NAME: The alert name (string).
ALERT_URL: The alert page URL (string).
QUERY_NAME: The associated query name (string).
QUERY_URL: The associated query page URL (string).
QUERY_RESULT_TABLE: The query result HTML table (string).
QUERY_RESULT_VALUE: The query result value (string or number).
QUERY_RESULT_ROWS: The query result rows (value array).
QUERY_RESULT_COLS: The query result columns (string array).

An example subject, for instance, could be: Alert "{{ALERT_NAME}}" changed status to {{ALERT_STATUS}}.

You can also use HTML to format messages in a custom template. The following tags and attributes are allowed in templates:

Tags: <a>, <abbr>, <acronym>, <b>, <blockquote>, <body>, <br>, <code>, <div>, <em>, <h1>, <h2>, <h3>, <h4>, <h5>, <h6>, <head>, <hr>, <html>, <i>, <li>, <ol>, <p>, <span>, <strong>, <table>, <tbody>, <td>, <th>, <tr>, <ul>
Attributes: href (for <a>), title (for <a>, <abbr>, <acronym>)

topic Re: Databricks Alerts in Data Engineering

Databricks Alerts

Re: Databricks Alerts