Edit on GitHub
Email link
Email files to your destination with the Email Connector.
NOTE: The Email Connector is append-only.
Featureslink
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | ||
Custom data | check | All tables and fields |
Data blocking | check | Column level |
Column hashing | check | |
Re-sync | check | Connector level |
History | ||
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking |
Setup guidelink
Follow our step-by-step Email connector setup guide set up a Fivetran Email connector to send files to your destination.
Sync overviewlink
The Email Connector extracts one or more attachments from the email, parses the attachment data, and uploads it into your destination. Emails are deleted once attachments are extracted from them. Attachments are permanently backed up in an internal S3 bucket in case of a re-sync. This connector is designed for scheduled email reports.
Primary keyslink
Fivetran adds the following columns as composite primary keys for a table:
COLUMN | DATA TYPE | NOTES |
---|---|---|
_file 🔑 | TEXT | The file name received through the email |
_line 🔑 | INT | The line number in the file that was read |
_modified 🔑 | TIMESTAMP | The timestamp when we received an email containing files |
_directory 🔑 | TEXT | The folder path where the file is stored in internal S3 bucket. It follows the pattern groupId/schema/table/attachment/folder_created_to_store_file |