I’ve looked around the forum but the most recent post I found about this topic was from 2018.
I’m looking for a way to export query visualizations programmatically, hopefully without having to use tools such as selenium.
In case you’re wondering why I need this:
my company has several clients and they all want a goddamn monthly report. The CTO still doesn’t feel like making our Redash public to them, so I’d have to manually do this, which is just copypasting job and it’s dumb.
So I’m trying to build something like:
- a script that, each month, queries my dashboard with the needed parameters (client, date range)
- export the visualizations and embed them in an HTML template (using jinja2 maybe)
- save the HTML page as pdf and save it on an S3 bucket.
I would build this using AWS lambda functions, but if you have better ideas on how to obtain the above, please do share!
Edit: for the record, I’m using python so ideally I’d be working with that. Internally we also use JS but I don’t really wanna bother the frontend dev with this, he’s got enough to do already