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
Join key. Unique id of the content section. Matches the
response_used_content_id columns on claudia_prompt_revision.The trigger text: what a customer question has to look like for this section to be retrieved.
Whether reaching this section escalates the conversation.
true marks sections that exist to hand the customer to a person.N1 for a section that answers, N2 for one that escalates, INTERACTIVE for one that offers the customer options.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.Whether the section was deleted. Filter both this and
disabled_flag out to get the base as the agent sees it today.When the datamart last wrote this row. Use it to spot sections that changed since your previous load.