Skip to main content

Snowflake Documentation

Queries (Snowflake)

From the Queries page, you can access comprehensive information about all the queries linked to the Unravel-monitored warehouses. You can explore, filter, analyze your queries, and efficiently manage your queries from this page.

The Queries page helps you to :

  • Filter queries efficiently

    Filter your queries using filters such as Query ID, time period, user, warehouse, status, insights, cost, duration. This allows you to pinpoint queries that match your criteria precisely.

  • Explore queries

    Explore similarities among queries by selecting Same Signature Queries and compare different queries to understand their performance. This helps you identify areas for improvement and optimization.

  • Streamline the query management process

Filtering Snowflake Queries
  1. On the Unravel UI, select Queries.

  2. Select any of the following filters from the left panel. The Queries are listed on the right based on the filter selections.


    In the Unravel Snowflake UI, query reflection may exhibit delays, especially for data polling queries. To help mitigate these delays and improve query reflection, consider increasing compute capacity by adding more clusters when more unravel queries are in a running state or queued state. For example, if your warehouse is of size X_SMALL, raising the minimum cluster count to X based on warehouse load should enhance query visibility and response times.

    Use the toggle button at the top of the page to display the inefficient queries only. By default, the Show inefficient queries only filter is displayed.

    The total number of queries that meet the filtered criteria is displayed at the top of the page.




    Query ID

    Query ID to filter the queries with the required ID.


    Queries started in a specific period. These can be Today, seven days, 14 days, one month, three months, six months or one year. You can also select the required time period with the date picker.



    User to filter the queries with the required user.



    Warehouse to filter the queries that belong to the selected warehouse.



    Status of the query. The options are Success and Failed.



    The queries attached to the selected insight are displayed.



    Use the sliders to set the minimum and maximum values for the cost. The queries that fall in that range are listed.



    Select the duration of the queries run to filter the queries.

  3. A table with the following columns shows the filtered list of queries.


    • All the columns in the queries list table can be sorted in ascending and descending order.

    • Specify a keyword in the search-icon.png search box, and the queries matching the keyword are immediately listed.

    • Click download.png to download the job list in a CSV format.

    • From display-no-of-items-per-page.png, you can select the number of query items that you want to be listed on a page. This can be 10, 15, 25, 50 and 100.

    • Use the paginationpagination.png to move to any of the pages in the query list table.

    Query list columns



    Checkboxes are provided in this column to choose two jobs for comparison. Refer to Comparing Snowflake Queries for more details.

    Query ID

    The query ID is listed. You can click the link of a query ID to view the job details page for that query.


    The SQL text is listed.


    The status of the query is listed.


    The number of insights for the specific query ID is displayed. Click the query ID .

    Estimated Cost

    The estimated cost for the specific query is listed along with the credits.


    The users who run the query are listed.

    Warehouse Name

    The name of the warehouse which belongs to the specific query is listed.


    The start date and time of the query is listed.

    End time

    The query end time is listed.


    The duration for which a query has run is listed.

    Same signature queries

    Click the Same signature query link to view a list of queries having the same signature as the selected query.

Comparing Snowflake Queries

Use the compare jobs feature within the queries section to ensure the smooth execution of your queries while meeting SLAs. For instance, if you get an alert informing you that one of your query is taking longer to complete, you can compare the query with another query to figure out the underlying issue and resolve it. In such cases, you can compare the current run with a previous one with a typical duration.


At a time, you can compare only two jobs, the current one with another.

To compare Snowflake Queries, do the following:

  1. On the Unravel UI, click Queries

  2. Select any two queries from the queries table and click the Compare Queries > Compare button on the lower right.


    The Compare Queries page displays the differences because the Show differences toggle is turned on by default. You can turn off the Show differences toggle to check all the query details other than the differences.

  3. You can compare the following aspects of the jobs:

    • Query details

    • Warehouse

    • Insights

    • Input tables

    • Output tables

    • Metrics


    • Click the View Query link to view the query details page of that specific query.

    • Click any links in the upper right section to jump to that specific section and view the comparison details.

    • Use the Show differences toggle to showcase only the differences between the two jobs or to view all the details.