# Extracting Usage Analytics Data

> You can run SQL queries to extract data from ElastiCubes, including the Usage Analytics ElastiCube. This data is collected and stored in a CSV file. You can download this CSV file with the SQL Runner.

*Source: https://docs.sisense.com/main/SisenseLinux/extracting-usage-analytics-data.htm*

---

Last updated: June 10, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

You can run SQL queries to extract data from ElastiCubes, including the Usage
Analytics ElastiCube. This data is collected and stored in a CSV file. You can
download this CSV file with the SQL Runner with the following call:

`http://localhost:8081/api/datasources/LocalHost/Usage%20Analytics%20Model/sql?query=select%20*%20from%20usage&format=csv`

In this example, LocalHost is the name of the server where the Usage Analytics ElastiCube is
located. If you are connecting remotely, change this to the IP address or name of the server as defined in the Data
Sources table in the **Admin** page of Sisense.

customizing-user-roles

**Note:**

Following security enhancements made in Sisense V7.0 and later, this feature is only available to Administrators. You
can allow additional user roles to access it by [Customizing User Roles](https://docs.sisense.com/main/SisenseLinux/customizing-user-roles.md).

  

For more information, see [SQL Runner](https://developer.sisense.com/display/API2/SQL+Runner.htm).