Managing Verified Queries in Kyvos for Enhanced Data Insights

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 for AI Space, perform the following steps.

1. From the Toolbox, click AI Space.

2. Select an AI Space from the list. 

3. Click Properties and then select the Context tab.
   
   

   Open

   

4. Click to expand the Verified Queries section and click the Add Queries. The Manage Verified Queries dialog is displayed.
   
   

   Open

   

    

5. In the Queries panel, click the + icon to add a new query, or select an existing query from the list.

6. In the Natural Language Query text box, enter the business question in plain language (for example, “What is sum sales for 2025?”).

7. In the SQL Query editor, enter the corresponding SQL statement using Spark SQL syntax.

8. (Optional) Click Execute Query to validate and test the SQL query.

9. In the Additional Context field, provide additional context to clarify the intent or usage of the query.

10. In the Applicable For field, select the relevant users for whom this query should be available.

11. Enable Show as suggested questions in Dialogs if you want this query to appear as a suggested question in Kyvos Dialogs.

12. Repeat the above steps to add more natural language queries as required.

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

Open

Deleting Natural Language Queries

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

Open

 Importing Queries

You can import sample queries in CSV format and use them to query the semantic model.

To import sample queries, perform the following steps.

1. From the Toolbox, click Semantic Models.

2. Select a semantic model from the list. 

3. Click the AI Settings tab and then select the Context tab.

4. Click Import Queries. The Import Verified Queries dialog is displayed.

5. Select the Choose file option to upload the file. The file will be uploaded.

6. Specify the settings as: line separator, field separator, and enclosed as needed.

7. Click Import. The CSV file will be imported.
   
   

   Open

   

    

Exporting Queries

This section details how to export sample queries in CSV format.

To export sample queries, perform the following steps.

1. From the Toolbox, click Semantic Models.

2. Select a semantic model from the list. 

3. Click the AI Settings tab and then select the Context tab.

4. Click Export Queries at the bottom of the page. The Export Sample Queries dialog is displayed.

5. Specify the settings as: line separator, field separator, and enclosed as needed.

6. Click Export. The CSV file will be exported.

Open