Send Email via Python

Send an email message from a Matillion ETL orchestration job, as a notification or alert.

It can send an email using any SMTP server that allows a username/password login.

For simplicity the password is passed as a parameter. As an alternative for improved security, you may wish to alter this Shared Job to use your own password management service such as AWS KMS, Azure Key Vault or GCP Cloud KMS.

Two Python packages are used: smtplib and ssl. These are preinstalled on Matillion ETL.

Sending with Gmail

You must have a password for your account. If you are using 2-Step Verification on your Google Account, follow these instructions to set up an app password.

• Set the SMTP password to your 16-character app password (remove the spaces)
• Set the SMTP server to smtp.gmail.com

Downloads

Licensed under: Matillion Free Subscription License

• Download Send-Email-via-Python.melt
  • Target: Any target cloud data platform
  • Version: 1.60.1 or higher

Installation Instructions