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.

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 modal

From a Worksheet: Click on the database icon all the way to the left in your Worksheet’s toolbar.

From a Dataset: Open the ‘Worksheet’ tab in your Dataset, and click on the database icon all the way to the left in your Dataset’s toolbar.

From a Dashboard: If you are not already in edit mode, click the `Edit` button on the right side of your Dashboard's toolbar. Next, click on the database icon, also in the toolbar.

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.

Pausing Queries

If you would like to make changes to your document without automatically running queries against your warehouse, you can pause queries by clicking the pause button in the left side of your document toolbar.
Queries can be resumed at any time by clicking the play button.