Scheduled reports by email

[arikfr]

No description provided.

[tanminhnu]

Hi arikfr,

Does the re:dash project support the daily email reports?

[arikfr]

@Thomasmisfit not at the moment, but it's high on the list of next things to implement.

[vincetse]

👍

Any thoughts when this might get on the roadmap again? It'll be a pretty neat feature to have.

[arikfr]

@thelazyenginerd it's on the roadmap, but I can't commit on specific dates for feature releases.

[ChiragKParmar]

@arikfr this would be really good feature to have.

[arikfr]

@ChiragKParmar I agree :-)

[shahneil88]

@arikfr - Would this flow be ideal?

1. Run a cron to query the DB at said time interval.
2. Save the query result in a file (Somewhere in /opt/redash folders).
3. Run a python job to pick up that file , attach it and send email to designated email address

[arikfr]

@shahneil88 it's possible, but then why use Redash? IMO, a better approach would be to get the query result from Redash via the API, and send it by email.

I even have an example script that does that:
https://gist.github.com/arikfr/a730451c01d1dd326412

[alenave]

@arikfr has this feature implemented?

[abeniwal]

+1

[arikfr]

@alenave it wouldn't be open if it was implemented...

[pjatx]

@arikfr thanks for the script! going to adapt for my org now.

[ultymike]

+1

[rahul-pande]

+1

[nickihm]

+1

[gamefundas]

+1 a much awaited feature for ReDash

[praneeth-sajepa]

+1

[foaadnami]

+1

[arpitset]

+1

[sandeep89]

+1

[asafmaor]

+1

[yoavbls]

+1

[aanari]

+1

[Miggleness]

+1

[brad-natelborg]

+1

[macEar]

+1

[shivakumarss]

+1 still its open :(

[lrader]

Love all the requests from people who simply consume. @arikfr You do an amazing job staying positive when responding to the comments. I love redash, thank you for all the time you put into it.

[lpanjwani]

+1

[aviam]

+1 we really need this feature

[mayank924]

Need this feature

[jontonsoup]

+1 this is amazing it doesn't exist

[jazz788]

Just an fyi for anyone in a bind. Metabase does what I think some of you may be looking for. It's not a png - its some kind of formatted charts, or tables, it is not super sophisticated but we find it really helpful for supplementing client reporting. One bug on metabase is it does not work on some outlook for some companies depending on their setup and/or security. We have not figured out the exact reason yet.

[arunlodhi]

+1

[jesseforrest]

+1

We are having to create crons that interact with redash in order to send email, which is not ideal. This feature would be incredibly powerful.

[marionita]

+1 for this feature, it would be extremely useful.

[melvinmt]

Would be great if we can also get a scheduled report in Slack :)

[dobesv]

To get a report in slack you can use the slack redash connector and the /remind command. Just set a reminder with a link to a report and the slack redash tool will embed a preview of the report into slack each time the reminder fires.

https://redash.io/slack/

[melvinmt]

@dobesv oh cool, I had no idea that would work! thanks - I no longer have a need for email reports this way :)

[jcolinger3]

Hmm. So any action on this?

[dobesv]

I suppose if people are serious about this feature they might have to hire someone to add it, or do it themselves. Doesn't seem to be a priority for the core developers who undoubtedly have a lot of other work on their plate, much of which they might even get paid to do.

[jcolinger3]

I guess that is one problem with open source. Like you said, just not enough money for devs to develop a robust solution.
Request is most thumbed up and been in for 6 years. Not going to get a large following of users (paid or not) when important feature requests are ignored.

[shivakumarss]

Was assuming this ticket will be picked up or addressed when databricks took over redash, but no luck.

[brad-natelborg]

Agree with above comments. This would be a really nice feature that feels like is lacking when compared to other BI tools currently.

[warwickchapman]

I’m happy to consider paying for some of this work but I would need it to be defined by someone. I’m a little unclear about the long term plan for the project though.

[susodapop]

Thanks for your interest @warwickchapman. We're putting together a more robust system for work planning on the OSS version. Overall aim is to more tightly define expected behaviour for new features, increase timeline transparency, and in general just make it easier/nicer to contribute to Redash. More to be announced on discuss.redash.io following the V10 release.

[azisso]

+1
Any takers?

[eradman]

A solution to this was recently made available by Starfish Storage under the BSD 2-Clause License used by Redash:

https://github.com/StarfishStorage/redash-email

Each dashboard listed in the configuration file is rendered as a PDF using a headless instance of Chrome. Query results can also be included as a CSV attachment.

One limitation to be aware of is that dashboards with text parameters are not supported until #6785 is resolved since dashboards are rendered using the share link.

[justinclift]

@gaecoli ^^^ That might be interesting to you. 😄

@eradman Is that something that would be good to have merged into the main Redash project at some point?

[eradman]

@justinclift having this functionality built into the main Redash project would be good, but from my perspective the real work is to make Redash itself more amenable to this sort of operation! If Redash was designed to support this kind tool the actual page rendering would be very simple.

[justinclift]

Cool. Makes good sense to me too. 😄

[gaecoli]

@gaecoli ^^^ That might be interesting to you. 😄

@eradman Is that something that would be good to have merged into the main Redash project at some point?

I will try it when I have time.

[justinclift]

@eradman Wonder if we should create a new wiki (to start with) page for stuff like "Useful extensions and add-ons to Redash"?

Obviously it would list your redash-email project, and we can add others to it over time that seem useful + maintained as well.