Knowledge Base Article

Export a table from the elasticube to a CSV

* Disclaimer: This works for Windows only. It will work in future with Linux versions as well. Once it does, I will update the post. Sometimes, we need to export a table from the Elasticube to a CS...
Updated 02-09-2024
Data: Elasticube Management
Elasticube
Plugins
Windows
Anonymous's avatar
Anonymous
05-24-2024

*****UPDATE*****

Now, you can do the same thing on Linux as well. Using the 0.9 REST API: 
GET​/datasources​/{cubeName}​/sql 

https://something.sisense.com//api/datasources/ECName/sql?count=-1&includeMetadata=true&format=csv&query=Select%20%2A%20From%20TABLE_NAME

Hope this helps. 
Happy exporting ðŸ™‚

 

About APIs

Node avatar for APIs
Docs for using the Sisense APIs
89 ArticlesCreated: 6 months agoLatest Activity: 04-10-2025