How to configure the Email Report component to email pipeline results as a table, CSV, or text attachment in your Integrate.io ETL pipeline.
The Email Report component is a terminal (destination) component that emails the rows reaching it at the end of a pipeline. Use it to deliver a small result set, summary, or alert directly to people’s inboxes as an inline table and/or a CSV or text attachment, without writing to a warehouse or file store first.It is designed for digests and notifications, not bulk export: large inputs are trimmed to a sample (see Limits). For the full data set, write to a file or warehouse destination instead.
Select at least one output, otherwise the email would carry no data.
Option
Description
Preview the rows as a table in the email body
Renders the rows as an HTML table in the email body (previews up to 1,000 rows).
Attach the rows as a CSV file
Attaches the rows as a CSV file. Optionally set the file name (default report.csv).
Attach the rows as a text file
Attaches the rows as a tab-delimited text file. Optionally set the file name (default report.txt).
The CSV and text attachments are mutually exclusive: you can select one or the other (or neither). The body table is independent and can be combined with either attachment.
Enabled by default. The job fails if the email cannot be delivered, so an undelivered notification surfaces as a job failure rather than a silent success. Disable for fire-and-forget notifications that should not affect the job result.
When the input is too large for one email
Truncate and send (default): the report is trimmed to a sample and notes how many rows there were. Fail the job: stops the job so nothing is silently dropped.
By default, reports are sent from reports@integrate.io. To send from your own domain, configure the account-level Email Sender settings (Settings > Account Settings > Email Sender).
Field
Description
From address
The address reports are sent from.
From name (optional)
The display name recipients see.
Reply-to (optional)
The address recipient replies are sent to.
The sending domain must be approved for your account before it can be used. Contact support to enable a new sending domain.
Q: Where are Email Report emails sent from?From reports@integrate.io by default. You can configure a custom sending domain in the Email Sender account settings.Q: What happens if my data is larger than the limits?By default the report is trimmed to a sample and the email notes how many rows there were. Choose Fail the job under “When the input is too large for one email” if a partial report is not acceptable. For the full data set, use a file or warehouse destination.Q: Can I attach both a CSV and a text file?No. The CSV and text attachments are mutually exclusive. You can include one of them (or neither), and the in-body table is independent.Q: Why did my job fail with an email error?“Fail the job if the report email cannot be sent” is enabled by default, so a delivery failure fails the job. Check that any custom sending domain is approved for your account.
