Examine Sigma Queries

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. By default, Sigma sets query timeouts to 120 seconds (2 minutes). Organization admins have the option to customize this per connection.
	Errored	Something went wrong. Open the query detail view to view the error message.
	Paused	Queries are paused on your document. To restart queries, click on the play button in your document toolbar.
	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 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.