Adding Natural Language Queries

This section details how to add Natural Language Queries (NLQ) in Kyvos to allow users to ask questions about their data in plain business language and automatically generate relevant queries or insights.

This feature enables users to define commonly used business questions in natural language and map them to corresponding SQL queries, store them at different access levels, and leverage them both as suggested prompts in chat sessions and as reference examples for RAG-based SQL generation. These verified questions help improve SQL generation accuracy by providing contextual guidance during conversational analytics experience with Kyvos Dialogs.

To add natural language queries, perform the following steps.

From the Toolbox, click Semantic Models.
Select a semantic model from the list.
Click the AI Settings tab and then select the Context tab.
Click Manage Queries. The Manage Verified Queries dialog is displayed.
In the Queries panel, click the + icon to add a new query, or select an existing query from the list.
In the Natural Language Query text box, enter the business question in plain language (for example, “What is sum sales for 2025?”).
In the SQL Query editor, enter the corresponding SQL statement using Spark SQL syntax.
(Optional) Click Execute Query to validate and test the SQL query.
In the Additional Context field, provide additional context to clarify the intent or usage of the query.
In the Applicable For field, select the relevant users for whom this query should be available.
Enable Show as suggested questions in Dialogs if you want this query to appear as a suggested question in Kyvos Dialogs.
Repeat the above steps to add more natural language queries as required.
Click Apply to save the configuration. You can also click Cancel to exit without saving changes.

Editing Natural Language Queries

You can edit natural language queries by clicking the pencil edit icon. The Manage Verified Queries dialog is displayed. Make the necessary changes and click Apply.

Deleting Natural Language Queries

You can delete natural language queries by clicking the delete icon. The query will be deleted.