Skip to main content
Custom field values in long format, one row per field. Pivot on your side — the set of fields differs per workspace, so the export cannot pivot for you.

One row is

one conversation, one custom field

Delivery

Rewritten daily

Columns

19

​
Where it lands

The partition delivered today holds the whole table. Read the latest 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 conversation_custom_field_name.
​
bigint
Internal warehouse key for the conversation. Use conversation_id.
​
bigint
Account the conversation belongs to.
​
varchar(50)
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.
​
bigint
Join key. Conversation the field belongs to. Joins to cloud_chat_conversations.
​
bigint
Number shown to agents for that conversation.
​
timestamp
When the conversation was created.
​
varchar(255)
Name of the custom field. The set of names is defined per workspace, so this is the column you pivot on.
​
varchar(65535)
Value of the field, always as text regardless of how it is typed in the workspace. Cast on your side.
​
bigint
Id of the field definition in the workspace.
​
timestamp
When this value was last changed.
​
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.