Documentation

Using Calculations
-
Integrations
-

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 Worksheet based on the data returned by your query. You will then be able to use Sigma's spreadsheet-like interface to further explore your data. Simply click the button that says 'Create Worksheet'.

<style type="text/css">
.tg  {border-collapse:collapse;border-spacing:0;}
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:black;}
.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;border-color:black;}
.tg .tg-0lax{background-color:#dceeff;text-align:left;vertical-align:top}
.tg .tg-tf2e{text-align:left;vertical-align:top}
.tg .tg-f86a{background-color:#f8f8f8;text-align:left;vertical-align:top}
@media screen and (max-width: 767px) {.tg {width: auto !important;}.tg col {width: auto !important;}.tg-wrap {overflow-x: auto;-webkit-overflow-scrolling: touch;}}</style>
<div class="tg-wrap"><table class="tg">
 <tr>
   <th class="tg-0lax"><span style="font-weight:bold">Mac Shortcut</span></th>
   <th class="tg-0lax"><span style="font-weight:bold">PC Shortcut</span></th>
   <th class="tg-0lax"><span style="font-weight:bold">Command</span></th>
 </tr>
 <tr>
   <td class="tg-tf2e">CMD + Enter</td>
   <td class="tg-tf2e">CTRL + Enter</td>
   <td class="tg-tf2e">Submit query for execution</td>
 </tr>
 <tr>
   <td class="tg-f86a">CTRL + Space</td>
   <td class="tg-f86a">CTRL + Space</td>
   <td class="tg-f86a">Open autocomplete</td>
 </tr>
 <tr>
   <td class="tg-tf2e">CMD + /</td>
   <td class="tg-tf2e">CTRL + /</td>
   <td class="tg-tf2e">Toggle commenting on or off for the highlighted line</td>
 </tr>
 <tr>
   <td class="tg-f86a">CMD + Left</td>
   <td class="tg-f86a"></td>
   <td class="tg-f86a">Go to the start of the line</td>
 </tr>
 <tr>
   <td class="tg-tf2e">Tab</td>
   <td class="tg-tf2e">Tab</td>
   <td class="tg-tf2e">Indent line</td>
 </tr>
 <tr>
   <td class="tg-f86a">Shift + Tab</td>
   <td class="tg-f86a">Shift + Tab</td>
   <td class="tg-f86a">Indent less</td>
 </tr>
 <tr>
   <td class="tg-tf2e">Shift + CTRL + K</td>
   <td class="tg-tf2e">Shift + CTRL + K</td>
   <td class="tg-tf2e">Delete current line</td>
 </tr>
 <tr>
   <td class="tg-f86a">CMD + L</td>
   <td class="tg-f86a">CTRL + L</td>
   <td class="tg-f86a">Select line</td>
 </tr>
 <tr>
   <td class="tg-tf2e">CMD + CTRL + Up</td>
   <td class="tg-tf2e">Shift + CTRL + Up</td>
   <td class="tg-tf2e">Shift line up</td>
 </tr>
 <tr>
   <td class="tg-f86a">CMD + CTRL + Down</td>
   <td class="tg-f86a">Shift + CTRL + Down</td>
   <td class="tg-f86a">Shift line down</td>
 </tr>
 <tr>
   <td class="tg-tf2e">CMD + J</td>
   <td class="tg-tf2e">CTRL + J</td>
   <td class="tg-tf2e">Join Lines</td>
 </tr>
 <tr>
   <td class="tg-f86a">Shift + CMD + D</td>
   <td class="tg-f86a">Shift + CTRL + D</td>
   <td class="tg-f86a">Duplicate line</td>
 </tr>
 <tr>
   <td class="tg-tf2e">CMD + K CMD + K</td>
   <td class="tg-tf2e">CTRL + K CTRL + K</td>
   <td class="tg-tf2e">Delete the portion of the line to the right of the cursor</td>
 </tr>
 <tr>
   <td class="tg-f86a">CMD + K CMD + delete</td>
   <td class="tg-f86a">CTRL + K CTRL + Backspace</td>
   <td class="tg-f86a">Delete the portion of the line to the left of the cursor</td>
 </tr>
 <tr>
   <td class="tg-tf2e">CMD + K CMD + U</td>
   <td class="tg-tf2e">CTRL + K CTRL + U</td>
   <td class="tg-tf2e">Upcase at cursor</td>
 </tr>
 <tr>
   <td class="tg-f86a">CMD + K CMD + L</td>
   <td class="tg-f86a">CTRL + K CTRL + U</td>
   <td class="tg-f86a">Downcase at cursor</td>
 </tr>
</table></div>