How to use Synapse pipeline to send alert email using Python notebook, but hide username and password to mail server.

Question

How to use Synapse pipeline to send alert email using Python notebook, but hide username and password to mail server.

NUNZIATA, Frank (NHS RESOLUTION) 20

I have been asked to create a notebook that can be included in a Synapse pipeline to send alert emails. The examples I have seen use the mail server credentials in the python script. How do I hide these? Server is Outlook.

Thanks in advance

Smaran Thoomu 35,375 Reputation points Microsoft External Staff Moderator

2024-10-24T14:46:09.5666667+00:00

@NUNZIATA, Frank (NHS RESOLUTION) Just checking in to see if the below answer provided by @hossein jalilian helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer accepted by question author

0 additional answers

Your answer

Smaran Thoomu 35,375 Reputation points Microsoft External Staff Moderator

2024-10-24T14:46:09.5666667+00:00

@NUNZIATA, Frank (NHS RESOLUTION) Just checking in to see if the below answer provided by @hossein jalilian helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

hossein jalilian 13,360 Volunteer Moderator

Thanks for posting your question in the Microsoft Q&A forum.

You can use Azure Key Vault to store and retrieve the sensitive information.

Create secrets in Azure Key Vault for your email username and password.
Ensure your Synapse workspace has access to the Key Vault.
Create a linked service in Synapse that connects to your Key Vault.
Use the Synapse SDK to access the Key Vault secrets.
Use the retrieved credentials to authenticate and send the email.

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful

Smaran Thoomu 35,375 Reputation points Microsoft External Staff Moderator

2024-10-25T11:56:12.6933333+00:00

@NUNZIATA, Frank (NHS RESOLUTION) Just checking in to see if the below answer provided by @hossein jalilian helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

How to use Synapse pipeline to send alert email using Python notebook, but hide username and password to mail server.

0 additional answers

Your answer