Skip to main content
The tag dimension. Join from cloud_chat_conversations_tags when you need a tag’s description as well as its name.

One row is

one tag

Delivery

Rewritten daily

Columns

12

​
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 — join on tag_id or tag_name.
​
varchar(36)
Identifier of the workspace the tag 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. Unique id of the tag.
​
bigint
Account the tag is defined in.
​
integer
Instance the workspace is served from.
​
varchar(255)
The tag as agents see it. Joins to tag_name on cloud_chat_conversations_tags.
​
varchar(65535)
What the tag is for, as written by whoever created it. Often the only place the intended meaning is recorded.
​
timestamp
When the tag was created.
​
timestamp
When the tag was last edited.
​
date
Partition column. Date of the delivery that wrote this file, in YYYY-MM-DD.