topic Re: How can I send custom email notification in Data Engineering

How can I send custom email notification

keeplearning — Mon, 09 Jan 2023 11:04:22 GMT

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

Re: How can I send custom email notification

RKNutalapati — Mon, 09 Jan 2023 15:02:25 GMT

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

Re: How can I send custom email notification

LandanG — Mon, 09 Jan 2023 15:05:13 GMT

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

Re: How can I send custom email notification

Yash-Verma — Mon, 21 Oct 2024 07:51:51 GMT

I am trying alerts option to send an email but when I am trying to add email address in destination it is not allowing me to add. Only user id it is allowing. Please help. Also, I am trying to send emails directly from notebooks using SMTP server provided by my company but again timeout error is coming

Re: How can I send custom email notification

Panda — Mon, 21 Oct 2024 11:50:03 GMT

@keeplearning

There are three approaches I can think of for this:

Approach 1: Creating an email template and sending emails programmatically from DBX Notebook.
Approach 2: Invoke a Logic App via an Azure REST API from Databricks after the code executes successfully or in the failure (catch) block.
Approach 3: Invoke a Webhook that internally triggers a Logic App to send an email using a predefined template.

Re: How can I send custom email notification

Kundan579 — Thu, 04 Dec 2025 12:02:10 GMT

Anybody tried to configure the custom email notification using logic app POST URL? asking because i am stuck not able to configure with right way, basically i am deploying the job using DAB, and i have created a logic app with custom email, now i am stuck at the job level configuration to send the notification to webhook, where i am not able to find the way, i tried by creating the destination at workspace level and tried to add in job yaml at task level using webhook_notification but looks like not working , not sure what i am missing. Can someone guide if they have already configured this solution.