> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cloudhumans.com/llms.txt
> Use this file to discover all available pages before exploring further.

# claudia_contents

> What the agent could draw on when it answered. Join from `claudia_prompt_revision` to see which section produced a given reply.

What the agent could draw on when it answered. Join from `claudia_prompt_revision` to see which section produced a given reply.

<Columns cols={3}>
  <Card title="One row is">
    one content section
  </Card>

  <Card title="Delivery">
    Rewritten daily
  </Card>

  <Card title="Columns">
    21
  </Card>
</Columns>

## Where it lands

```text theme={null}
s3://<YOUR_BUCKET>/v1/datamart_claudia/claudia_contents/snapshot_date=<DATE>/
```

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](/data-export/bucket-layout#how-to-tell-if-a-partition-is-ready).

## Columns

<ResponseField name="idsentry_sk" type="bigint">
  Internal warehouse key. Not stable between deliveries — join on `content_id` instead.
</ResponseField>

<ResponseField name="content_id" type="varchar(255)">
  **Join key.** Unique id of the content section. Matches the `response_used_content_id` columns on [`claudia_prompt_revision`](/data-export/catalog/claudia/claudia_prompt_revision).
</ResponseField>

<ResponseField name="project_name" type="varchar(50)">
  Project whose knowledge base the section belongs to.
</ResponseField>

<ResponseField name="content_title" type="varchar(65535)">
  Title of the section, as written by whoever maintains the base.
</ResponseField>

<ResponseField name="content_text" type="varchar(65535)">
  The trigger text: what a customer question has to look like for this section to be retrieved.
</ResponseField>

<ResponseField name="content_response_text" type="varchar(65535)">
  The answer the agent is expected to give when it uses this section.
</ResponseField>

<ResponseField name="tag_name" type="varchar(255)">
  Subject tag the section is filed under.
</ResponseField>

<ResponseField name="is_n2_flag" type="boolean">
  Whether reaching this section escalates the conversation. `true` marks sections that exist to hand the customer to a person.
</ResponseField>

<ResponseField name="topic_name" type="varchar(255)">
  Topic grouping above the tag.
</ResponseField>

<ResponseField name="content_type" type="varchar(50)">
  `N1` for a section that answers, `N2` for one that escalates, `INTERACTIVE` for one that offers the customer options.
</ResponseField>

<ResponseField name="flow_id" type="varchar(255)">
  Controlled flow this section starts, when it starts one. `NULL` for a plain answer.
</ResponseField>

<ResponseField name="created_at" type="timestamp">
  When the section was created.
</ResponseField>

<ResponseField name="updated_at" type="timestamp">
  When the section was last edited.
</ResponseField>

<ResponseField name="source_metadata_class" type="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.
</ResponseField>

<ResponseField name="draft_flag" type="boolean">
  Whether the section is still a draft and not yet usable by the agent.
</ResponseField>

<ResponseField name="disabled_flag" type="boolean">
  Whether the section is turned off. Disabled sections stay in the export for history.
</ResponseField>

<ResponseField name="excluded_flag" type="boolean">
  Whether the section was deleted. Filter both this and `disabled_flag` out to get the base as the agent sees it today.
</ResponseField>

<ResponseField name="tenant_id" type="varchar(256)">
  Id of the tenant. `NULL` for rows with no tenant mapping.
</ResponseField>

<ResponseField name="tenant_name" type="varchar(256)">
  Name of the tenant. `NULL` for rows with no tenant mapping.
</ResponseField>

<ResponseField name="etl_updated_at" type="timestamp">
  When the datamart last wrote this row. Use it to spot sections that changed since your previous load.
</ResponseField>

<ResponseField name="snapshot_date" type="date">
  Partition column. Date of the delivery that wrote this file, in `YYYY-MM-DD`.
</ResponseField>
