Send Email
Overview
The Send Email component lets users send emails via an orchestration job in Matillion ETL. Users may wish to use this component to send email notifications upon any job failures.
Some SMTP servers will not allow the Sender Address property to be different from the SMTP Username (for example, Outlook and Gmail). This means that whatever is shown in the SMTP Username property will be used as the value of the "From" when the email is sent, and the Sender Address property will be ignored. This is beyond Matillion's control.
Depending on your configuration, it is safest to assume that email is an unencrypted medium. Therefore, it is recommended to avoid including sensitive content in the email message. Instead, it is recommended to provide trusted URLs through which such context could be securely accessed.
Depending on the SMTP server, users may need to have Enable SSL/TLS set to Yes and Enable StartTLS set to No, and vice versa.
Properties
Name = string
A human-readable name for the component.
To Recipients = email addresses editor
Click + to add a recipient to send the email to, and then type the recipient's email address into the field. Each recipient must be its own row.
Cc Recipients = email addresses editor
Click + to add a recipient to send a carbon copy of the email to, and then type the recipient's email address into the field. Each Cc recipient must be its own row.
Subject = string
A subject for the email.
Message = string
The contents of the email body.
Sender Address = string
The email address from which the email is sent.
Reply Address = string
The address that will receive any recipient and/or Cc replies.
SMTP Username = string
The username for your SMTP client.
SMTP Password = string
The corresponding password for your SMTP client. Store the password in the component, or create a managed entry for the password using Manage Passwords (recommended).
SMTP Hostname = string
The host address for your SMTP server. For example, if you use Gmail, the SMTP hostname is smtp.gmail.com. Typically, an SMTP email server address can be found in the "account" or "settings" sections of the email client.
SMTP Port = integer
Set the port number. The default is 25.
Enable SSL/TLS = drop-down
Select whether to enable SSL/TLS encryption.
Enable StartTLS = drop-down
StartTLS is an email protocol command that directs an email server that an email client—including an email client running in a web browser—wants to turn an existing insecure connection into a secure one.
| Snowflake | Delta Lake on Databricks | Amazon Redshift | Google BigQuery | Azure Synapse Analytics |
|---|---|---|---|---|
| ✅ | ✅ | ✅ | ✅ | ✅ |