Graph a select count(*) without requiring an intermediate service or database (for point-in-time snapshots, timeseries data)

[dagelf]

It strikes me that Redash already has all the infrastructure to trivially support this, without requiring yet another intermediary service that duplicates most of the already included functionality.

Eg. I want to graph select count(*) from openissues. I do not have write access to the database.

Yes, I did read this post which says "Redash isn't a data warehouse".

Is there a compelling reason why I should build this time series functionality into Redash, which can already:

• query the source database
• schedule periodic tasks
• cache / store results

It seems silly to build middleware that would effectively need to duplicate this functionality, just so redash can run YET ANOTHER query over it.

PS Very new here, just discovered this project yesterday, after spending a few days building something similar.