How can I send custom email notification

[keeplearning]

I am using the edit notification in databricks to send email notification in case of workflow failure or success. How can I add additional information to this report for example if I want to notify about number of rows got processed or added how can I do this

[RKNutalapati]

Hi @Rohit Kapoor​ :

There is a new format for job emails, this can be enabled from Admin console -> Workspace settings

I think any additional information apart from above image can be appended to the error message in catch block of your program.

Another option is to implement a function to send mails, so you can customize your message and send it on success/ failure.

Hope this helps

Thanks,

RKNutalapati

[LandanG · Accepted solution]

@Rohit Kapoor​ If you want more control over notifications I'd check out Alerts in DB SQL. You can set custom Alert Destinations and create SQL queries for fine-grained control. For example, you can jobs to schedule a DLT pipeline to run and then trigger an alert right after to send an email with how many rows were processed or how many rows failed.

[Kaniz]

Hi @Rohit Kapoor​, We haven’t heard from you on the last response from @Rama Krishna N​ and @Landan George​​, and I was checking back to see if their suggestions helped you.

Or else, If you have any solution, please share it with the community, as it can be helpful to others.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.