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.

    Note

    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.

    Snow-queries.png

    Filter

    Description

    Query ID

    Query ID to filter the queries with the required ID.

    Started

    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.

    SF-Started.png

    User

    User to filter the queries with the required user.

    SF-User.png

    Warehouse

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

    SF-Warehouse.png

    Status

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

    SF-Status.png

    Insights

    The queries attached to the selected insight are displayed.

    SF-Insights.png

    Cost

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

    SF-Cost.png

    Duration

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

    SF-Duration.png
  3. A table with the following columns shows the filtered list of queries.

    Tip

    • 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

    Description

    Compare

    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.

    SQL

    The SQL text is listed.

    Status

    The status of the query is listed.

    Insights

    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.

    user

    The users who run the query are listed.

    Warehouse Name

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

    Started

    The start date and time of the query is listed.

    End time

    The query end time is listed.

    Duration

    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.

Note

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.

    Note

    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.

    SF-query-compare.png
  3. You can compare the following aspects of the jobs:

    • Query details

    • Warehouse

    • Insights

    • Input tables

    • Output tables

    • Metrics

    Tip

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