SQL Editor to run output of Analyse SQL

I looked at "Analyse SQL" and at "Query Plan Analyser". Both are useful. In this case, they helped me confirm that a widget-measure-filter's "having" clause is applied after the various measures and dimensions have been grouped. But that's not my request.

My feature request is that I want to run the SQL in the SQL Editor. I'm not sure of all the use cases, but here are some ideas:

• Check the "raw" results of the query.
• Run a subquery. E.g. "My widget isn't showing row X. Is that because the 'having' clause excludes it, or was it never in my measure's subquery?"
• Edit the query. E.g. "I know the SQL formula I want for my measure. I'll try it in the SQL query to see if it behaves as expected within the filters/dimensions I'm using. Then I'll build it in my Sisense measure."
• To read a measure formula in a more familiar language.
• Other - It helps me develop and debug if I can run some code like this.

Some colleagues are familiar with SQL but new to Sisense. I think they'd feel a more comfortable if "they can see exactly what the query is doing", and even more comfortable if they can run some SQL to check how it behaves. Some might even write a formula in SQL and ask me to help them translate it into Sisense, which would be an excellent learning experience.

hey Tim ,

Reading the SQL sometimes can be confusing as the SQL contain nested select and also D Tables (which are tables that translate String Keys into integer). 

I do suggest to review the Query Plan Analyzer for analyzing the Query flow.

Best Regards

Hi Tim,

Does the Query Plan Analyzer work for you?

Hi Tim,

Thank you for sharing your idea and providing details.

We encourage people to continue to vote and comment. We use community interest as one of the ways we prioritize efforts, so every vote and comment can help turn a request into a reality.

Thank you again for sharing and being part of our community!