tags_list column on cloud_chat_conversations when you need to group or filter by tag.
One row is
one conversation, one tag
Delivery
Rewritten daily
Columns
17
Where it lands
snapshot_date= partition only, and check for _SUCCESS before you do, as
described in bucket layout.
Columns
bigint
Internal warehouse key. Not stable between deliveries — the row is identified by
conversation_id plus tag_name.bigint
Internal warehouse key for the conversation. Use
conversation_id.bigint
Account the conversation belongs to.
integer
Instance the workspace is served from.
varchar(36)
Identifier of the workspace the row belongs to.
varchar(256)
Id of the tenant.
NULL for rows with no tenant mapping.varchar(256)
Name of the tenant.
NULL for rows with no tenant mapping.integer
Join key. Conversation the tag was applied to. Joins to
cloud_chat_conversations.bigint
Number shown to agents for that conversation.
timestamp
When the conversation was created. Carried here so you can filter by period without joining.
varchar(256)
The tag. Joins to
tag_name on cloud_chat_tags when you also need the tag’s description.timestamp
When the tag was applied. The gap from
conversation_created_at tells you whether it was tagged on arrival or at closing.varchar(255)
Agent assigned to the conversation, carried here for convenience.
varchar(65535)
Inbox of the conversation, carried here for convenience.
varchar(255)
Team of the conversation, carried here for convenience.
timestamp
When the datamart last wrote this row.
date
Partition column. Date of the delivery that wrote this file, in
YYYY-MM-DD.