Sections in this category

Creating & Managing Queries

  • Updated

Sisu uses queries to form “flat tables” from your data that are used in building analyses.

 

Related Articles:

 

Creating a New Query

To create a new Query:

  1. Access the Data module from the top navigation bar, then click Manage Queries next to the desired Data Source.

    Select_Manage_Queries.png

  2. Click + to add a new query.

    Create_New_Query.png

  3. Type a Title for the query in the “Untitled query” field.
  4. Use the SQL editor to structure your new query.
  5. Click Run to preview the results in the Table Preview section of the screen.
  6. Make any adjustments to the query needed based on your review of the preview.
  7. Click Save query.
    This query can be now be used as a source for a new metric.

    info_icon.png Once a query has been created, it will be shared with and accessible by all members of the organization.

 

 

Editing an Existing Query

warning_icon.png Queries can be edited at any time, even if they are being used for an Analysis. However, if the query is being used for an Analysis, it cannot be removed or renamed, and the data type cannot be changed.

 

To edit an existing query:

  1. Access the Data module from the top navigation bar, then click Manage Queries next to the desired Data Source. 

    Select_Manage_Queries.png

  2. Select an existing query from the list.
  3. Use the SQL editor to edit the query as needed.
  4. Click Run to preview the results in the Table Preview section of the screen.
  5. Make any adjustments to the query needed based on your review of the preview.
  6. Click Save query.