With the SQL Runner, you can run standard SQL queries on data within an ElastiCube, and see results in a JSON format.
To access the SQL Runner:
sqlrunner#datasource=:ElastiCubeNameat the end of the Sisense web URL. For example: If the Sisense URL is
localhost:8081, and the ElastiCube is called "Training", type in
For Sisense 7.2 Beta Users
In Sisense V7.2 Beta, the location has been changed to
For more information, please see the v7.2 Developer Release Notes
You can also run SQL queries using API calls from your own tools. The syntax below executes an SQL query against a data source, and returns json results:
For example: sales.city count(*) from sales group by sales.city
The example returns the city name and number of occurrences from the sales table, and corresponds to the SQL statement below:
Select city, count(*)
Group By city
Your results can also be downloaded in a CSV format by adding the &format=csv query parameter.
Example:sales.city count(*) from sales group by sales.city&format=csv
If you are connecting to a remote server and want to download your data in CSV, the name of the remote server or its address must be included in the API call
In the example above, remoteserver represents the location of where the name or address of the remote server should be defined in your call. This source should be defined in the Data Sources table of the Admin page in Sisense.
Sisense Usage Analytics collects usage information for your Sisense system. This information is collected and stored in a CSV file. You can download this file with the SQL Runner with the following call: