sample_queries - Composite topics

Defines a list of sample queries that could be performed on the composite topic, which is used:

To present example queries when a composite topic is selected in the workbook or using the Omni Agent. To hide the query, set the hidden parameter to true.
By the Omni Agent to improve results. To exclude the query from the composite topic’s AI context, set the exclude_from_ai_context to true.

You can add a workbook query to this parameter using one of the following methods:

From the Model menu: Click Model > Save as sample query to topic in the workbook.
From the inspector: Click the near the bottom left corner of the page to open the workbook inspector. Click Copy query and visualization YAML in the inspector header to copy the query and visualization configuration in the sample query format, then paste it into your composite topic file in the model IDE.

Syntax

sample_queries:
  <query_name>:
    query:
      fields: [ "<field_one>", "<field_two>", ... ]
      base_view: "<composite_topic_name>"
      calculations:
        <calculation_name>:
          sql: "<sql_expression>"
      limit: <number>
      sorts:
        - field: "<field_name>"
          desc: true/false
      topic: "<composite_topic_name>"
    description: "<query_description>"
    hidden: true/false
    prompt: "<natural_language_prompt>"
    ai_context: "<ai_context_description>"
    exclude_from_ai_context: true/false

Properties

object

required

The name of the sample query (e.g., “Summary Stats”). Each query is defined as a key in the sample_queries object.

Hide query properties

object

required

The query definition object containing the structure of the query to be executed.

Hide query properties

string[]

required

List of fields to include in the query. Can include shared dimensions, shared measures, and per-topic fields from the composite topic.

string

required

The composite topic to query from.

object

Optional calculations to include in the query. Each calculation is defined with a name and SQL expression.

Hide calculation properties

string

required

The SQL expression for the calculation.

number

Maximum number of rows to return.

object[]

List of fields to sort the results by.

Hide sort properties

string

required

The field name to sort by.

boolean

default:"false"

When set to true, sorts the field in descending order. Omit or set to false to sort in ascending order.

string

The name of the composite topic used in the query.

string

required

A human-readable description of what the query does or what insights it provides.

boolean

default:"false"

When set to true, hides the query from being presented as an example query in the workbook or embedded Omni Agent.

string

A natural language prompt that represents how a user might ask for this query. Used by the Omni Agent.

string

Additional context to help the Omni Agent understand how to use this query or what it demonstrates.

boolean

default:"false"

When set to true, excludes this query from the composite topic’s AI context, preventing the AI from using it as a reference.

Examples

sample_queries:
  Cross-Topic Summary:
    query:
      fields: [ shared_date.month, order_items.sale_price_sum, marketing.spend_sum, calc_1 ]
      base_view: orders_marketing_composite
      calculations:
        calc_1:
          sql: OMNI_FX_SAFE_DIVIDE(${order_items.sale_price_sum}, ${marketing.spend_sum})
      limit: 1000
      sorts:
        - field: shared_date.month
          desc: true
      topic: orders_marketing_composite
    description: Monthly revenue, marketing spend, and revenue per dollar spent
    hidden: false
    prompt: show me monthly revenue compared to marketing spend with ROI
    ai_context: demonstrates querying across multiple topics with a shared date dimension and custom calculation for ROI
    exclude_from_ai_context: false

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

sample_queries - Composite topics

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples