topic Re: Formatting on Databricks Alerts in Data Engineering

Formatting on Databricks Alerts

Nick_Hughes — Tue, 09 Nov 2021 12:22:15 GMT

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?

Re: Formatting on Databricks Alerts

Nick_Hughes — Tue, 09 Nov 2021 13:36:43 GMT

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

Re: Formatting on Databricks Alerts

Nick_Hughes — Wed, 10 Nov 2021 10:30:12 GMT

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?

Re: Formatting on Databricks Alerts

Nick_Hughes — Wed, 10 Nov 2021 11:22:54 GMT

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

Re: Formatting on Databricks Alerts

Nick_Hughes — Mon, 15 Nov 2021 15:58:07 GMT

@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?

Re: Formatting on Databricks Alerts

Prabakar — Tue, 16 Nov 2021 16:49:29 GMT

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.