โ11-09-2021 04:22 AM
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?
โ11-16-2021 08:49 AM
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.
โ11-09-2021 05:03 AM
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.
โ11-09-2021 05:36 AM
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
โ11-10-2021 02:30 AM
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?
โ11-10-2021 03:22 AM
@Kaniz Fatmaโ could you please help in the absence of a community response please? ๐
โ11-10-2021 07:28 AM
Hi @Nick Hughesโ ,
Indeed. I'll get back to you shortly.
โ11-15-2021 07:47 AM
Hi @Nick Hughesโ , The entire documentation is here:-
โ11-15-2021 07:58 AM
@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?
โ11-16-2021 08:49 AM
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.
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.