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 CSV file.
We can then import it to the next build, to send it to a colleague, to back up or any other usage.
(In the Sisense Desktop version, we could have done it using the export to CSV post plugin. However, this is not available in the WEB ECM).
The method described below utilities the API call:
http://localhost:8081/api/datasources/LocalHost/ECName/sql?query=select%20*%20from%20TableName&format=csvIf there are spaces in the name of the EC or of the table name, use %20.
Happy exporting 🙂
Updated 02-09-2024
