sample_queries

Defines a list of sample queries that could be performed using the topics in the model, which is used:

To present example queries when a model is selected in the workbook or using the embedded version of 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 model’s AI context, set the exclude_from_ai_context to true.

You can also add sample queries to individual topics.

Syntax

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

Properties

query_name

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

query

object

required

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

Hide query properties

fields

string[]

required

List of fields to include in the query. Can reference model fields or calculations.

base_view

string

required

The base view or topic to query from.

calculations

object

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

Hide calculation properties

sql

string

required

The SQL expression for the calculation.

limit

number

Maximum number of rows to return.

sorts

object[]

List of fields to sort the results by.

Hide sort properties

field

string

required

The field name to sort by.

desc

boolean

default:"false"

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

topic

string

The name of the topic used in the query, if applicable.

description

string

required

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

hidden

boolean

default:"false"

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

prompt

string

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

ai_context

string

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

exclude_from_ai_context

boolean

default:"false"

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

Examples

sample_queries:
  Summary Stats:
    query:
      fields: [ order_items.sale_price_sum, users.count, calc_1 ]
      base_view: order_items
      calculations:
        calc_1:
          sql: OMNI_FX_SAFE_DIVIDE(${order_items.sale_price_sum}, ${users.count})
      limit: 1000
      sorts:
        - field: order_items.sale_price_sum
          desc: true
      topic: order_items
    description: Total Revenue, Users and Revenue per User
    hidden: false
    prompt: show me total revenue, count of users and revenue per user
    ai_context: uses a calculation to compute avg. revenue per user
    exclude_from_ai_context: false

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples