sample_queries - Model files

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

object

required

A map of queries, where each key is the name of a sample query.

Hide sample_queries 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 reference model fields or calculations.

string

required

The base view or 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 topic used in the query, if applicable.

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 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

sample_queries - Model files

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples