Importing Data with Custom Queries

Sisense allows you to import data from a variety of data sources and manipulate the data that is imported by running custom SQL queries against the database, for example:

After running your custom query, you can preview the updated tables before importing the data into the ElastiCube.

Notes:

To add tables with custom queries:

  1. After selecting your database, click + at the bottom of the list of tables and views in the database. An empty custom table is added and the Settings area is displayed.

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

  2. In the Settings area, enter your custom SQL query.
  3. Click + to add additional custom tables. You can delete any of the tables by selecting the import query’s menu and clicking Delete.
  4. Click Done to import your custom data into Sisense.