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_atColumns
33
Where it lands
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
Instance the workspace is served from. Named
instance here, and instance_id on the other tables.Join key. Conversation the message belongs to. Joins to
cloud_chat_conversations.Which side sent the message:
Contact for your customer, User for an agent. NULL on the automated entries the workspace writes itself.incoming, outgoing, activity or template. activity rows are the workspace’s own notes, not something a person typed.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.The message as it was sent. Free text written by your customer or your agent, so treat it as personal data.
The same message after the workspace expands templates and variables.
NULL when there was nothing to expand.When the message record was last modified, for example when the channel confirmed delivery.
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.
Name of the WhatsApp template the message used.
NULL when the message is not a template.Category of the template as declared when it was sent:
MARKETING, UTILITY or AUTHENTICATION. Not every way of sending records it, so it can be NULL on a template message. For what Meta charged, use meta_pricing_category.billable as reported by Meta when the message was delivered. Meta is phasing this field out: read meta_pricing_type and meta_pricing_category together instead.Category Meta billed the message under:
marketing, utility, authentication, authentication_international, service or referral_conversion. Meta reports it when the message is delivered, and it is recorded since November 2026: older messages, and messages that were never delivered, are NULL. Like message_status, it is the value on the day the row was delivered to you and is not restated later.regular when Meta charges the message at the rate of meta_pricing_category. free_customer_service for a reply inside the 24-hour customer service window and free_entry_point for one inside a free entry point window; both cost nothing.