Feature Request: GUI for Query Authoring

Question

Are there plans in the future to provide an authoring environment for StreamInsight?

In the SSRS Report Designer there is a canvas that the user can use to author their report queries.  This type of GUI would make the creation of standing queries more accessible to less technical authors (i.e. those who do not know LINQ or DBAs who would like to experiment with queries without doing C# programming).

Jay

Answer 1

Hi Jay,

Thanks for bringing up the question about a graphical GUI for query authoring and how we could help non-developers write queries and analytics for StreamInsight. While this is technically feasible, the main question for us is about how we would surface this in a way that is meaningful for the user. We could provide graphical metaphors for joins, grouping, aggregation etc. Would this provide the right intuition for the users that you have in mind.

It would be best if you could share some more context with us on the customers, users, roles, and personas that you envision using this capability of StreamInsight. How would the ideal experience look like for those users that you have in mind?

This is an interesting topic - I am looking forward to your reply!

Thanks,
Torsten

---

This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

Wanted to bring this topic back to life...

One use case I have right now is around system integration.  Using StreamInsight for real-time calculations, sometimes created on the fly during periods of analysis, is a key area I want to explore.  However, the users intended to create the ad hoc analyses need not know that StreamInsight is processing their queries so they need a GUI for defining the queries within a system they are already familiar with.  The system, like many others, is extensible so a StreamInsight query designer GUI would allow the queries to be defined and stored in the system, and a StreamInsight host application would parse the system for queries and create them in the background with results making their way back to the same system.

In the 2 years since the topic was started has there been any developments in this visual query designer area?

Answer 3

Nope.

And keep in mind that StreamInsight 2.1 introduced a completely new model for adapters ...

---

DevBiker (aka J Sawyer)
Microsoft MVP - Sql Server (StreamInsight)

---

---

If I answered your question, please mark as answer.
If my post was helpful, please mark as helpful.

Answer 4

You mean Rx providing an adapter-less approach?  Either way, the concept is still the same...you bring in a payload, the payload is queried, the output payload is pushed to destination.  The querying of the payload is where I am interested in the GUI.  For the initial narrow, and somewhat basic, scope I have I will look to  build something custom anyway.