Skip to main content
This gem runs in .

​
Overview

Use the Email gem to send output tables from your pipeline to others via email. You can configure static values for recipients, subject, and body, or dynamically populate these fields from columns in your input dataset using the Use column option.

​
Input

The Email gem supports one or two input ports, depending on how you want to provide email content and attachments.
  • Single input port: The dataset can be used for both email content (To, Cc, Bc, Subject, Body) and attachment data (if enabled).
  • Two input ports: The first input port provides email content and parameters, while the second port provides attachment data.
The gem will send email(s) when it runs. No output table will be written to your data warehouse.

​
Parameters

Review the following Email gem parameters. Parameters can be set manually or configured dynamically using the Use column option. When you enable the Use column checkbox, the gem field is automatically populated with the value from the specified column in your input dataset.

​
Example

Suppose you have a dataset that you want to sent to different recipients.
  • Input port 1: Email parameters dataset
  • Input port 2: Attachment dataset
To send the attachment data to the recipients in the table:
  1. Connect the email parameters dataset to port 1 of the Email gem.
  2. Connect the attachment dataset to port 2 of the Email gem.
  3. Open the Email gem.
  4. Enable the Use column checkbox for To and Body fields.
  5. Select the columns from input 1 that correspond to the email parameters.
  6. Enable Include Data as Attachment to attach the dataset as an XLSX or CSV file.