Examine Sigma Queries – Sigma Computing

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 modal

From a Worksheet: Click on the database icon all the way to the left in your Worksheet’s toolbar.
Screen_Shot_2020-06-15_at_4.29.46_PM.png

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.
Screen_Shot_2020-06-15_at_4.29.22_PM.png

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.

Screen_Shot_2020-07-01_at_6.41.18_PM.png

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

Screen_Shot_2020-06-15_at_6.07.29_PM.png

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.

Screen_Shot_2020-06-15_at_4.47.01_PM.png

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 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’ and ‘Execution Time’:

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.

Please Note: 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’.

Screen_Shot_2020-07-30_at_2.04.04_PM.png

Limitations

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

Pausing Queries