โ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 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