Includes all chat messages tracked in Affinity with sender, direction, and metadata.
Name: chat_messages
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 | Unique identifier for the chat message |
logging_type | Indicates how the interaction was added to Affinity: either manually by a user or automatically through Affinity’s capture process. Currently, chat messages can only be logged as ‘manual’. |
direction | The direction of the chat message |
sent_at | Timestamp indicating when the chat message was sent |
creator_id | The ID of the creator of the chat message |
created_at | Timestamp indicating when the chat message was created in Affinity |
is_deleted | Whether the chat message record has been deleted |
last_updated_at | Timestamp when this record was last updated |
