Using Custom SQL to Import Data

Applicable to Sisense on Linux and Microsoft Windows

Create custom SQL queries to manipulate the data that you want to import, for example:

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

Notes:

To create a custom SQL query:

  1. After connecting to your data, click Edit.
  2. Select Manual Query Input, and type in your query.
  3. Click Apply Table. Your preview will update to reflect the query.
  4. You can now click Add to import the data based on your SQL query.