Email Message
This object is contained once per Email Message Synced Event. Each Email Message contains instances of Email Participant.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| ID | Varchar | This is the message ID (various by mailbox provider) of this mailing. | ||
| DATE | Timestamp_NTZ | A datetime (local to server) in which the row was last modified. date can be used to identify updated and new records, but as tables may not see changed records every day, it is not authoritative on when the table was last synced. | 2019-01-01 12:14:01:10 | Where date::date >= current_date-7 This will return all rows modified in the last 7 days. |
| DIRECTION | Varchar | A string describing the direction type. | 'EMAIL_MESSAGE_DIRECTION_UNKNOWN', 'DIRECTION_OUTBOUND', 'DIRECTION_INBOUND' | |
| FROM | Variant | This is the email participant associated with `from` email message field. | ||
| TO | Array | This is a list of email participants associated with `to` email participants. | ||
| REPLY_TO | Variant | This is a email participant associated with the `reply_to` email participant. | ||
| CC | Array | This is a list of email participants associated with carbon copy email participants. | ||
| BCC | Array | This is a list of email participants associated with blind carbon copy email participants. |