How can I turn JAQL query into a SQL query?
currently we are using JAQL to query data that we use to create some reports.. but now we want to get the same data by using SQL so I looking for a way to convert our JAQL queries into an equivalent ...
Forum Discussion
It's the following api: POST /datasources/{cubeName}/jaql/sql
I tested that endpoint and actually it returned a SQL query based on my JAQL query but that sql query was generated with the table names modified.. I meat that the it added other letters to my table names...
and when I tried to execute those SQL queries on this api : /api/datasources/{cubeName}/sql?query=
it returns error:in some sql queries return this error
"status": 401,
"httpMessage": "Unauthorized"
in other returns :
"error": true,
"details": "{\"error\":\"Query could not be compiled.\\nFound '.' but expected ')'.\\nFound '.' but expected '<Identifier>'.\\nFound '.' but expected ')'.\\nFound '.' but expected '<Identifier>'.\\nFound '.' but expected '<End of Expression>'.\"}",
"type": "500",
do you know if do i need to take into account something that i did not be awarethe sql generated is doing a INNER JOIN with a table that does not exist (i do not have any table in our cube with that name)
Only admins can run sql?query= if I am not mistaken. That jaql/sql endpoint is the only endpoint that translates jaql to sql. If it isnt usable, then I am afraid there is no way to translate a jaql to sql within Sisense itself. You would have to translate it somehow yourself unfortunately.
