Comments (76)
Thanks all. Please do not post +1s: we know this is an open issue. :)
from redash.
This issues was opened in 2013 and it 2019 now, is there any plan to do this ?
I'm not sure for how long you been using the project, but it's not like we been sitting on our hands in this time :-) It just so happens that this feature didn't hit our roadmap yet.
from redash.
from redash.
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.
from redash.
@arikfr suggested we use the API to email the report as CSV. That is ok but the killer feature is to email a specific configured dash board with charts, graphs and the raw CSV report data on an interval (nightly or weekly). Sure we can write code to scrape the dashboard HTML and use that as our email body but it isn't as nice
from redash.
@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
from redash.
Actually with Zapier you need a paid plan to really use it well for this purpose. I created a serverless AWS project that can be used to run a report and email it on a schedule, since I don't have any other use for Zapier right now:
https://github.com/dobesv/redash-scheduled-email
from redash.
Hey guys i managed to send reports of each query in CSV form in mail, Please is there a way to send reports in png screenshots form.
from redash.
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.
from redash.
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.
from redash.
@arikfr - Few months since last post on this, any roadmap plans yet? Feature would be amazing!
from redash.
+1 this is amazing it doesn't exist
from redash.
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.
from redash.
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.
from redash.
@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.
from redash.
+1
from redash.
I'll cast my vote for this longstanding request to be implemented as well.
from redash.
Just installed redash, and for some reason I was thinking this is naturally there. But is not. Any Idea this will ever arrive? Before we look further.
from redash.
7 years since this was opened. :)
I don't think this is part of the overall vision.
from redash.
+1 still its open :(
from redash.
+1 we really need this feature
from redash.
Need this feature
from redash.
+1
Any takers?
from redash.
Hi arikfr,
Does the re:dash project support the daily email reports?
from redash.
@Thomasmisfit not at the moment, but it's high on the list of next things to implement.
from redash.
š
Any thoughts when this might get on the roadmap again? It'll be a pretty neat feature to have.
from redash.
@thelazyenginerd it's on the roadmap, but I can't commit on specific dates for feature releases.
from redash.
@arikfr this would be really good feature to have.
from redash.
@ChiragKParmar I agree :-)
from redash.
@arikfr - Would this flow be ideal?
- Run a cron to query the DB at said time interval.
- Save the query result in a file (Somewhere in /opt/redash folders).
- Run a python job to pick up that file , attach it and send email to designated email address
from redash.
@arikfr has this feature implemented?
from redash.
+1
from redash.
@alenave it wouldn't be open if it was implemented...
from redash.
@arikfr thanks for the script! going to adapt for my org now.
from redash.
+1
from redash.
+1
from redash.
+1
from redash.
+1 a much awaited feature for ReDash
from redash.
+1
from redash.
+1
from redash.
+1
from redash.
+1
from redash.
+1
from redash.
+1
from redash.
+1
from redash.
+1
from redash.
I was able to cobble something together using Zapier that does this. Not ideal but I thought I'd share this workaround for anyone who wants it in the meantime:
Trigger: Schedule (Every Week)
You can get {query id} (a number) and {api key} (a random alphanumeric string) from them embed URL of the query.
Action: WebHooks by Zapier -> GET
URL
https://redash.vaultdrop.com/api/queries/{query id}/results.csv
Query String Params
api_key
= ...
Send as JSON
No
Action: Code by Zapier > JavaScript
Code
output = {html: `
<html>
<body>
<table colspacing=0 colpadding=0>
<thead>
<tr>
${inputData.csv.split('\n')[0].split(',').map(h => `<th style="text-align: right; padding: 2px">${h}</th>`).join('\n ')}
</tr>
</thead>
<tbody>
${inputData.csv.split('\n').splice(1).map(
(line, n) => `<tr>\n${line.split(',').map(v => `<td style="text-align: right; padding: 2px; background-color:${n&1?'#f2f2f2':'white'}">${v}</td>`).join('\n')}</tr>`).join('\n')}
</tbody>
</table>
</body>
</html>
`
};
Action: Mandrill > Send Email
Put the HTML output into the message body. Other mail sending methods that support HTML will work as well.
from redash.
@BouchaaraAdil Could you please share the code
from redash.
Hi,
This issues was opened in 2013 and it 2019 now, is there any plan to do this ?
I am asking this as this has come up as requirement from my client so before starting to invest in some workaround i wanted to check if there are any future plan for this feature.
from redash.
+1
from redash.
@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
hello, your url link is error, could you update it?
from redash.
+1 vote for this
from redash.
For PNG reports you could setup a scheduled job somewhere (AWS Lambda or a cron job on a server) that uses urlbox to pull a PDF or PNG of the page and send it somewhere.
from redash.
https://github.com/practo/redash-summary you can use this very basic table can be sent as an alert using this. You are welcome to contribute for any graphs PNG if you can.
from redash.
Having a way to send a dashboard as a PDF and/or an email with charts flatten as PNG on a regular basis or as trigger of an alert would be really awesome!
Doing it as an external service is working but a bit painful to maintain.
from redash.
+1 vote for this function.
it will be an amazing improvement if have this.
pdf version is enough for user.
from redash.
+1
from redash.
+1
from redash.
+1
from redash.
+1
from redash.
+1
from redash.
+1
from redash.
+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.
from redash.
+1 for this feature, it would be extremely useful.
from redash.
Would be great if we can also get a scheduled report in Slack :)
from redash.
@dobesv oh cool, I had no idea that would work! thanks - I no longer have a need for email reports this way :)
from redash.
Hmm. So any action on this?
from redash.
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.
from redash.
Was assuming this ticket will be picked up or addressed when databricks took over redash, but no luck.
from redash.
Agree with above comments. This would be a really nice feature that feels like is lacking when compared to other BI tools currently.
from redash.
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.
from redash.
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.
from redash.
@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?
from redash.
@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.
from redash.
Cool. Makes good sense to me too. š
from redash.
@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.
from redash.
Related Issues (20)
- Uncaught promise error in Edit Visualization Dialog Modal
- date parameter configuration in redash self hosting. HOT 3
- Redash does not connect to Microsoft SQL Azure HOT 2
- queury in queue issue
- SchedulerWorker doesn't refresh query HOT 1
- Redash can't refresh mongodb schema unless all collections are granted HOT 2
- How to customize data label in redash HOT 1
- Query Results Error When I Join Multitable
- How can I disable/hide filters in an embedded dashboard? HOT 1
- Problem with asset location server.css after setup on Ubuntu HOT 1
- Slack as Alert destination: URLs in messages posted to Slack are not clickable links HOT 1
- Downgrading then upgrading redash schemas doesn't work HOT 6
- DynamoDB Support (regression issue) HOT 2
- numberFormat and thousandsSep HOT 6
- How to add counter visualization clickable its is possible ? HOT 2
- Feature request: an installation script for Fedora! HOT 1
- Front end data type display exception HOT 7
- puppeteer issue with Apple Silicon chips HOT 19
- Data Source "Redshift (with IAM User/Role)" does not support Redshift Serverless HOT 2
- Redash adds `/redash` prefix if a string starts with `/api` HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
š Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. ššš
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ā¤ļø Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from redash.