Formatting on Databricks Alerts

[Nick_Hughes]

Hi Guys. I have looked at the formatting options and I'm still struggling to work out how to best format the email body of a databricks alert. I want to be able to selectively choose columns from the query and dispaly them in a table. Or even if i can't selectively choose columns, just put all the results in a nicely formatted table. Please can someone advise how best to approach this?

[Kaniz_Fatma]

Hi @Nick Hughes! My name is Kaniz, and I'm the technical moderator here. Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question first. Or else I will get back to you soon. Thanks.

[Nick_Hughes]

Hi thanks you for your response. It's quite urgent so if you have an example please can you share because there is next to zero documentation on how to do this

[Nick_Hughes]

can you use jquery in the email body or just html? it seems i need to convert the json in to a table but I don't think I can do that in html?

[Nick_Hughes]

@Kaniz Fatma​ could you please help in the absence of a community response please? 🙂

[Kaniz_Fatma]

Hi @Nick Hughes​ ,

Indeed. I'll get back to you shortly.

[Kaniz_Fatma]

Hi @Nick Hughes​ , The entire documentation is here:-

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

[Nick_Hughes]

@Kaniz Fatma​  this doesn't help, I've read the documentation thoroughly already (unless you are saying it has been updated today). I'm specifically asking how you take this string parameter and format in to something at all readible?

[Prabakar · Accepted solution]

Hi @Nick Hughes​ , unfortunately, this is not available for now. We have a feature request for the same. DB-I-4105 - SQL Alerts: Formatting message body when creating Custom Template

This feature has been considered by our product team and it will be available in the future.