Skip to main content
The text of every message in the workspace, in send order, with its channel status and whether it was private. The largest table in the export. For the conversation it belongs to, join cloud_chat_conversations; for only the messages a ClaudIA agent took part in, use claudia_messages.

One row is

one message

Delivery

Daily delta on etl_updated_at

Columns

27

​
Where it lands

Each partition holds only the rows the datamart ingested that day, so union every etl_date= partition to reconstruct the table. One of them is etl_date=__initial__, the first load, holding everything that preceded the earliest daily partition. Check for _SUCCESS before reading a partition, as described in bucket layout.

​
Columns

​
bigint
Internal warehouse key. Not stable between deliveries — join on messages_id.
​
bigint
Internal warehouse key for the conversation. Use conversation_id.
​
bigint
Internal warehouse key for the inbox. Use inbox_id.
​
bigint
Internal warehouse key for the account. Use account_id.
​
varchar(36)
Identifier of the workspace the message belongs to.
​
integer
Join key. Unique id of the message within its instance.
​
varchar(50)
Instance the workspace is served from. Named instance here, and instance_id on the other tables.
​
integer
Account the message belongs to.
​
integer
Inbox the conversation arrived in.
​
integer
Join key. Conversation the message belongs to. Joins to cloud_chat_conversations.
​
varchar(255)
Id the message carries on the channel it came from. NULL when the channel sends none.
​
bigint
Id of whoever sent it. An agent id when sender_type is User, a contact id when it is Contact.
​
varchar(50)
Which side sent the message: Contact for your customer, User for an agent. NULL on the automated entries the workspace writes itself.
​
integer
Numeric form of message_type.
​
varchar(16)
incoming, outgoing, activity or template. activity rows are the workspace’s own notes, not something a person typed.
​
integer
Numeric form of message_status.
​
varchar(16)
Delivery state on the channel: sent, delivered, read or failed. It is the state on the day the row was delivered to you and is not restated later.
​
integer
What kind of content the message carries, such as plain text or an interactive reply.
​
bigint
Macro that produced the message, when an agent sent it from one.
​
boolean
true for an internal note, visible to agents only. Your customer never saw these.
​
varchar(50000)
The message as it was sent. Free text written by your customer or your agent, so treat it as personal data.
​
varchar(65000)
The same message after the workspace expands templates and variables. NULL when there was nothing to expand.
​
timestamp
When the message was sent.
​
timestamp
When the message record was last modified, for example when the channel confirmed delivery.
​
varchar(256)
Id of the tenant. NULL for rows with no tenant mapping.
​
timestamp
When the datamart first wrote this row. It decides the partition the message lands in and does not change afterwards, so a later edit to the message is not delivered again.
​
varchar
Partition column. The day whose rows this file holds, in YYYY-MM-DD. Not a date type, because the initial load carries the literal __initial__ instead of a day.