Sigma’s Query display 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 also deep dive into individual queries to view their underlying SQL or investigate errors.
Summary of Content
Viewing Recent Queries
Viewing an Individual Query
Query Status Types
Query Runtime Breakdown
Pausing Queries
Viewing Recent Queries
The query history modal displays recent queries run from your open Worksheet, Dashboard, or Dataset within the existing session.
Your document’s individual query list will automatically show each query’s status, action type, start time and run time.
Opening the Query History modal
From a Worksheet: Click on the caret icon next to the refresh button all the way to the left in your Worksheet’s toolbar. Then click Query history...
From a Dataset: Open the ‘Worksheet’ tab in your Dataset, and click on the caret icon next to the refresh button all the way to the left in your Dataset’s toolbar. Then click Query history...
From a Dashboard: Click on the caret icon next to the refresh button in the left corner of your Dashboard's header. Then 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.
Viewing an Individual Query
Once you have opened the Query modal from your Worksheet, Dashboard, or Dataset, you can deep dive into an individual query by selecting the query from the available list.
From here you can 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 |
![]() |
Completed |
Your query ran successfully! |
![]() |
Running |
Your query is currently running. |
![]() |
Errored |
Something went wrong. |
![]() |
Paused |
Queries are paused on your document. |
![]() |
Canceled |
The query has been canceled. |
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 two parts 'Queue Duration', 'Execution Time’, and 'Other':
Queue Duration is the amount of time the query sits in Sigma’s queue prior to being sent to the warehouse.
Execution Time is the amount of time it takes for the query to be processed by the data warehouse.
Other: A query’s queue duration and execution time may not add up to the exact run time in milliseconds. This slight gap can be attributed to the time in which the request is being passed from Sigma to the warehouse and vice versa.
To view a query’s runtime breakdown, open the individual query view. Then click on the info icon to the right of the displayed ‘Run Time’.
Limitations
Incomplete queries do not display a detailed runtime breakdown. This feature is also not available for download/export requests.
Pausing Queries
You can pause queries to make changes to your document without automatically running queries against your warehouse. To pause or resume queries:
From a Worksheet: Click on the caret icon next to the refresh button all the way to the left in your Worksheet’s toolbar. Then click Pause queries or Resume queries.
From a Dataset: Open the ‘Worksheet’ tab in your Dataset, and click on the caret icon next to the refresh button all the way to the left in your Dataset’s toolbar. Then click Pause queries or Resume queries.
From a Dashboard: Click on the caret icon next to the refresh button in the left corner of your Dashboard's header. Then click Pause queries or Resume queries.