cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Formatting on Databricks Alerts

Nick_Hughes
New Contributor III

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Prabakar
Databricks Employee
Databricks Employee

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.

View solution in original post

5 REPLIES 5

Nick_Hughes
New Contributor III

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
New Contributor III

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
New Contributor III

@Kaniz Fatmaโ€‹ could you please help in the absence of a community response please? ๐Ÿ™‚

Nick_Hughes
New Contributor III

@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
Databricks Employee
Databricks Employee

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.

Connect with Databricks Users in Your Area

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