In our team we use redash quite extensively and we also use some of the graphs and dashboards for our customers. We wanted to manage the queries, visualizations and dashboards as code (as they really are). Hence we created a tool called redpush. It lets you define all in yaml and pushes it to your redash server. It requires some initial work, but then it is really nice because you can have it all automated from your CI/CD pipeline.
first of thanks a lot for sharing this, we were thinking about the necessity of having such a tool, really thankful for your work.
Editing the visualisations widgets in yml isn’t however something that would be very intuitive for us. I wish we could separate the sync of queries on one hand, and the edition of charts and co in the web.
Is that something that is doable with your tool? If not, how can we help?
I kind of agree that yaml isn’t the best way to have all those graphs. But we haven’t found yet a better way to do it. What we wanted is to version control them, and treat them as any other code (PRs, etc).
Our way of working is having two redash instances, in one we work and experiment, then we export the queries and graphs in yaml we use those as templates to be fed through a templating lib to the production redash. In that production there is only one user which can write queries (the one used by redpush from CI) and the other users have only read access. Hence the only way to change it is through the PR process.
And regarding the question, I think (I haven’t tested it though) if you create queries without graphs, they will work fine. Redash automatically adds a visualization that is the table view. And if you update one, if no visualizations are in the yaml redpush should not change the ones already available there. But as said I haven’t tested it.
Is this tool helps me writing python code inside redash ??
if not how to import python library iside redash after making python as data source
thanks @arikfr@mat
