claudia_prompt_revision to see which section produced a given reply.
One row is
one content section
Delivery
Rewritten daily
Columns
21
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
content_id instead.varchar(255)
Join key. Unique id of the content section. Matches the
response_used_content_id columns on claudia_prompt_revision.varchar(50)
Project whose knowledge base the section belongs to.
varchar(65535)
Title of the section, as written by whoever maintains the base.
varchar(65535)
The trigger text: what a customer question has to look like for this section to be retrieved.
varchar(65535)
The answer the agent is expected to give when it uses this section.
varchar(255)
Subject tag the section is filed under.
boolean
Whether reaching this section escalates the conversation.
true marks sections that exist to hand the customer to a person.varchar(255)
Topic grouping above the tag.
varchar(50)
N1 for a section that answers, N2 for one that escalates, INTERACTIVE for one that offers the customer options.varchar(255)
Controlled flow this section starts, when it starts one.
NULL for a plain answer.timestamp
When the section was created.
timestamp
When the section was last edited.
varchar(50)
How the section entered the base:
csv-import, scrapper for content pulled from a public page, or auto-suggestion for one proposed automatically and then accepted.boolean
Whether the section is still a draft and not yet usable by the agent.
boolean
Whether the section is turned off. Disabled sections stay in the export for history.
boolean
Whether the section was deleted. Filter both this and
disabled_flag out to get the base as the agent sees it today.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.timestamp
When the datamart last wrote this row. Use it to spot sections that changed since your previous load.
date
Partition column. Date of the delivery that wrote this file, in
YYYY-MM-DD.