Creating Custom Live Table Queries

Sisense allows you to manipulate live data directly from within Sisense by running custom SQL queries against the live data source, without modifying the data in the original data source. For example, you can do the following:

Once you defined custom fields/tables against the Live data source, these fields/tables have all the functionality of regular tables that reside within the Live data source.

Notes:

To add fields/tables with custom live table queries:

  1. In the Connect Wizard, click + by Add Table Query at the bottom of the list of tables and views. An empty custom table is added to the list, and the Settings area opens.

    OR When previewing an existing table, click Edit Query to modify the custom query.

    In the Settings area, enter or modify your custom SQL query.
  2. (Optionally) Give a descriptive name to your query.

  3. Click Parse to verify your query syntax before saving the query.

  4. Click Done to apply the live table query to the live data source.