Update for Query Results as Data Sources in OC


#1

The feature Using Query Results as Data Sources (https://redash.io/help/queries/using-datasets-as-data-sources.html) was marked as available only for hosted version and will be released to Open Source version after 1.0.0.

Right now redash reached 2.0.0. Is there any update on this?

It’s a really powerful feature.


#2

+1
I also would like to hear from that.
It would make everything so much more flexible.


#3

Since this is in version 4.0.0, I’ve been using it. At the moment, my primary request would be to add an additional field to the Query Results Data Source that lets me give them a more sane name that I can reference when creating a query. Right now, I might have:

SELECT cl.name, bq.count 
FROM query_48 bq
JOIN query_47 cl ON cl.char_id = bq.char_code;

and

SELECT cl.name, bq.count 
FROM query_45 bq
JOIN query_47 cl ON cl.char_id = bq.char_code;

… and it’s super duper easy to get confused. I’d rather be able to do something like:

SELECT cl.name, bq.count 
FROM my_friendly_name bq
JOIN my_other_friendly_name cl ON cl.char_id = bq.char_code;

Provide friendlier names/interface for query results table names and columns