Description:
Tracks the transmission of a message to an individual recipient. Includes the rendered content, the notification channel used, and delivery/read status, providing full visibility into the message lifecycle.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the message transmission. |
content |
TEXT | The content of the message that was transmitted. |
created_at |
TIMESTAMP_TZ | Timestamp when the transmission was created. |
delivered_time |
TIMESTAMP_TZ | Timestamp when the message was delivered to the recipient. |
notification_channel |
NUMBER | The channel through which the message was sent: 0 = SMS, 1 = EMAIL, 2 = PUSH, 3 = SLACK. |
notification_channel_name |
TEXT | String label for notification_channel. |
read_time |
TIMESTAMP_TZ | Timestamp when the recipient read the message. |
status |
NUMBER | Current status of the transmission: 0 = SENT_SUCCESS, 1 = SENT_ERROR, 2 = DELIVERED, 3 = READ, 4 = SILENCED. |
message_status_name |
TEXT | String label for status. |
subject |
TEXT | Subject of the message being transmitted. |
message_id |
NUMBER | Identifier of the message related to this transmission. |
recipient_id |
NUMBER | Identifier of the recipient of the message. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |