Includes all emails tracked in Affinity with sender, recipients, subject, and direction information.
Name: emails
Grant access to the Snowflake share only to users who are authorized to view all
organization data. There are no per-user or per-role visibility filters applied at the
share level.
Columns
| Column | Description |
|---|
id | The email’s unique identifier |
logging_type | Indicates how the interaction was added to Affinity: either manually by a user (‘manual’) or automatically through Affinity’s capture process (‘automated’). Currently, emails can only be logged as ‘automated’. |
direction | The direction of the email: ‘sent’ if the email was sent by an internal user and ‘received’ if the email was sent to an internal user |
sent_at | The timestamp of when the email was sent |
created_at | The timestamp of when the email was created in Affinity |
from | The email address of the participant who sent the email |
to_participants | Array of email addresses in the To field |
cc_participants | Array of email addresses in the CC field |
is_deleted | Whether the email record has been deleted |
last_updated_at | Timestamp when this record was last updated |
