When building data models with multiple data sources, it can be easy to lose sight of what fields are flowing from/to which queries. Having a utility in the Query Editor that could visualize the hierarchy would be very helpful (and should be straightforward to build) Each query would have a number of 'children'. The first 'child query' would be the source (have different icons for different data sources; note that the source could be a reference to another query). The other 'children' would be all of the merged queries. For these, it would be nice to show which fields are merged and what kind of join (e.g. inner, outer) is used in the parent query. For more complicated data models, I find myself building these hierarchies manually in flow-charting software like Visio. It really helps in debugging or when making changes / extensions to a model. The current 'flat' query list is cumbersome if you have a lot of queries, even when they are grouped.
frithjof_v
on:
Role Based Access Control for Variable Libraries
YSD
on:
Add Dataverse as a Real-Time Data Source
on:
CREATE a FUNCTION that allows to extract the exact...