Email files to your destination with the Email Connector.
NOTE: The Email Connector is append-only.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | ||
| History mode | ||
| Custom data | check | |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step Email connector setup guide set up a Fivetran Email connector to send files to your destination.
Sync overview
The Email Connector is designed for scheduled email reports. It 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. You may delete these attachments by deleting the email connector, contacting privacy@fivetran.com, or by reaching out to our customer support team.
Primary keys
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 |