SQL Runner

Explore your data warehouse using the SQL Runner, which lets you enter in any SQL query and see what the results will be.

If you have access to write SQL against your data connection, you will see a link to the SQL Runner in the left hand navigation panel.

Once you open the SQL runner, use the drop down menu to choose which connection to run your SQL against. Once you choose a connection, a tree lets you explore the schemas and tables of the data warehouse. Click on any table to preview the data from the table.

When writing SQL, type in keywords and Sigma will provide a list of autocomplete options helping you accurately fill in the correct table and column information.

To run your SQL query, click ‘Run’ or hit CTRL-Enter on a PC or CMD-Enter on a Mac.

When writing your query, you can still use the left hand menu to explore data tables. You can switch between the Table Preview and SQL results, letting you preview what columns you may want to use in joins.

You also have a history of the SQL queries you have run. Click ‘History’ in the left hand panel to see all of the SQL queries you’ve run against a particular connection.

Once you’ve completed your SQL query, you can choose to create a Dataset or worksheet based on the data returned by your query. Simply click the appropriate button at the top of SQL Runner.

Mac Shortcut PC Shortcut Command
CMD + Enter CTRL + Enter Submit query for execution
CTRL + Space CTRL + Space Open autocomplete
CMD + / CTRL + / Toggle commenting on or off for the highlighted line
CMD + Left   Go to the start of the line
Tab Tab Indent line
Shift + Tab Shift + Tab Indent less
Shift + CTRL + K Shift + CTRL + K Delete current line
CMD + L CTRL + L Select line
CMD + CTRL + Up Shift + CTRL + Up Shift line up
CMD + CTRL + Down Shift + CTRL + Down Shift line down
CMD + J CTRL + J Join Lines
Shift + CMD + D Shift + CTRL + D Duplicate line
CMD + K CMD + K CTRL + K CTRL + K Delete the portion of the line to the right of the cursor
CMD + K CMD + delete CTRL + K CTRL + Backspace Delete the portion of the line to the left of the cursor
CMD + K CMD + U CTRL + K CTRL + U Upcase at cursor
CMD + K CMD + L CTRL + K CTRL + U Downcase at cursor

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us