Cortex Analyst Verified Query Repository suggestions

Cortex Analyst monitors queries sent to your semantic model in order to identify potential new queries to add to your Verified Query Repository (VQR). Cortex Analyst maps similar queries to your verified query and responds based on your verified query’s SQL result.

A query is suggested for inclusion in the VQR if it meets the following criteria:

  • High frequency: The query is similar to others frequently submitted to your Cortex Analyst model.

  • Novelty: No existing query in your VQR for the model would provide a response.

Note

The ability to suggest verified queries requires enough availabile history for your semantic model. You won’t see VQR suggestions until your model has enough activity to surface queries that meet the two criteria.

Adding verified query suggestions

To view your model’s list of verified query suggestions, follow these steps:

  1. Sign in to Snowsight.

  2. In the navigation menu, select AI & ML » Cortex Analyst.

  3. Select the database, schema, and stage for your model.

  4. Select the Cortex Analyst model you want suggested queries for.

  5. In the right-side pane, select the Suggestions tab.

  6. To add a suggestion to your verified queries, select Review now. To remove a suggestion, select Dismiss.

    Reviewing a suggestion presents you with a view that allows you to edit the query and its generated SQL result.

  7. To add the reviewed suggestion to your VQR, select Save and continue. To cancel, select Exit.

  8. Optional: To generate a new list of verified query suggestions, refresh the Semantic Model editing page.

Language: English