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
bigint
Internal warehouse key. Not stable between deliveries — join on
contact_id instead.varchar(36)
Identifier of the workspace the contact 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. Unique id of the contact. Matches
contact_id on cloud_chat_conversations.varchar(255)
First name, or the whole name when the channel does not split it. Personal data of your customer.
varchar(255)
Email address. Personal data of your customer.
varchar(255)
Phone number, in the format the channel provided. Personal data of your customer.
integer
Account the contact belongs to.
integer
Instance the workspace is served from.
varchar(65535)
Attributes the channel supplied about the contact, serialized as JSON. The keys depend on the channel.
varchar(255)
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.
varchar(65535)
Custom attributes set in the workspace, serialized as JSON.
timestamp
When the contact was last active in any conversation.
integer
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.varchar(255)
Middle name, when the channel supplies one. Personal data.
varchar(255)
Last name, when the channel supplies one. Personal data.
varchar(255)
Location as reported by the channel. Not verified.
varchar(255)
Country as reported by the channel.
boolean
Whether the contact was blocked in the workspace.
timestamp
When the contact was first created.
timestamp
When the contact record was last modified.
date
Partition column. Date of the delivery that wrote this file, in
YYYY-MM-DD.