Documentazione
AI Chat Schema Context

A compact skeleton of the analytics tables relevant to a prompt that the human user can query, with their columns and sample queries, when the data ends and the SQL rules to follow. The full detail of a table, column or sample is at its href, which is relative to the base path of the API (.../analytics/ai-chat/queries/) and is called with the same userId parameter and Account header. A table with the detail summary has no columns, state or type values and sample queries; fetch its href before using it in a query. In a table with the detail full an empty list means there is none, except for examples, whose number is capped.

Caratteristiche
  • Data Context
    When the analytics data ends and how to treat to-date periods. Absent if the AI Chat service does not provide it.
  • Links Guidance
    When to follow the hrefs of this skeleton, as advised by the AI Chat service. Absent if the AI Chat service does not provide it.
  • Query Rules
    The SQL correctness rules to follow when writing queries for this schema. Absent if the AI Chat service does not provide them.
  • Tabelle
    The analytics tables relevant to the prompt that the human user can query, sorted by table name in ascending order; empty if no table matches the prompt. A table with the detail full carries its columns, state and type values and sample queries. A table with the detail summary has only name, description, sharded, detail and href, so fetch the table detail at its href before the table is used in a query.
  • Tables Href
    The href of the index of the tables the human user can query that the AI Chat schema catalog documents, for a table the prompt needs but the skeleton does not list. Absent if the AI Chat service does not provide it.
Staging 2.232.4