One row is
one contact
Delivery
Rewritten daily
Columns
23
Where it lands
snapshot_date= partition only, and check for _SUCCESS before you do, as
described in bucket layout.
Columns
Join key. Unique id of the contact. Matches
contact_id on cloud_chat_conversations.First name, or the whole name when the channel does not split it. Personal data of your customer.
Attributes the channel supplied about the contact, serialized as JSON. The keys depend on the channel.
Your own identifier for the contact, when your systems set one. This is the column to join on if you want to match the contact to a record in your CRM.
Numeric code for how the contact was created.
0 is a regular contact; other codes mark contacts created by the platform rather than by a real interaction.