Examine Sigma Queries (Worksheets & Dashboards)

IMPORTANT: This document is specific to Sigma worksheets & dashboards.

Sigma’s Query history modal is a powerful tool if you want to better understand your Sigma generated SQL queries.

The modal displays an overview of recent queries, their runtime and current status. You can deep dive into individual queries to view their underlying SQL or investigate errors.

Summary of Content

View Recent Queries
      View a Worksheet's Query History
      View a Dashboard's Query History
      The Query List
View an Individual Query
Query Status Types
Query Runtime Breakdown
Pause and Resume Queries

View Recent Queries

The query history modal displays recent queries run from your open document within the existing session.
Your document’s individual query list will automatically show each query’s status, action type, start time and run time.

View a Worksheet's Query History

  1. Click on the caret icon next to the refresh button all the way to the left in your worksheet’s toolbar.
  2. Click Query history...

 

View a Dashboard's Query History

  1. Click on the caret icon next to the refresh button in the left corner of your Dashboard's header.
  2. Click Query history...

 

The Query List

Your document’s query list will automatically show each query’s status, action type, start time and run time.

 

View an Individual Query

  1. Open your document's Query history modal (see View Recent Queries).
  2. Click the query you would like to learn more about.
  3. Explore the query detail view:
    • View and copy the Sigma generated SQL.
    • If the query failed, an error will also be displayed below Query Details.

 

Query Status Types

Symbol

Status

Description

Screen_Shot_2020-06-15_at_5.03.48_PM.png 

Completed

Your query ran successfully!

 Screen_Shot_2020-06-15_at_5.04.12_PM.png

Running

Your query is currently running.
By default, Sigma sets query timeouts to 120 seconds (2 minutes). Organization admins have the option to customize this per connection.

 Screen_Shot_2020-06-15_at_5.03.55_PM.png

Errored

Something went wrong.
Open the query detail view to view the error message.

 Screen_Shot_2020-06-15_at_5.04.00_PM.png

Paused

Queries are paused on your document.
To restart queries, click on the play button in your document toolbar.

 Screen_Shot_2020-06-15_at_5.07.45_PM.png

Canceled

The query has been canceled.
This may happen if additional changes are made to your document before the query is run. In such an instance, Sigma will run only the new query.

 

Query Runtime Breakdown

A detailed query runtime breakdown is available for successfully completed and timed out queries. Query runtimes can vary due to network traffic, queue delay, or data warehouse processing time. Sigma’s runtime breakdown allows you to see if and when your query encountered delays.

The runtime is broken into three parts: 

  • Queue Duration: the amount of time the query sits in Sigma’s queue prior to being sent to the warehouse.
  • Sigma runtime: the amount of time Sigma takes to process the query, excluding queue duration and warehouse time.
  • Warehouse runtime: the amount of time between when Sigma sends a request to your data warehouse and when it gets a response back. This is roughly the amount of time the warehouse spent running your query.

 

Note: Incomplete queries do not display a detailed runtime breakdown. This feature is also not available for download/export requests.

 

Pause and Resume Queries

You can pause queries to make changes to your document without automatically running queries against your warehouse.

Pause Worksheet Queries

  1. Click on the caret icon next to the refresh button all the way to the left in your worksheet’s toolbar.
  2. Click Pause queries or Resume queries.

 

Pause Dashboard Queries

  1. Click on the caret icon next to the refresh button in the left corner of your dashboard's header.
  2. Click Pause queries or Resume queries.

 

IMPORTANT: This document is specific to Sigma worksheets & dashboards.