We’re using Influx for time-series sensor data. Development with Influx is going swimmingly. However, we have one specific need that we haven’t figured out.
We know we’re going to have data analysis needs outside well-defined workflows and visualizations. This means ad hoc number crunching in Python, Mathematica, R, Excel, etc. CSV dumps are pretty much the defacto standard for importing data into these sorts of tools.
Of course, we’d rather not have our ad hoc data analysts interacting directly with the database. Similarly, we’d like to avoid relying on a single person specializing in formulating command line queries to extract needed data from Influx.
Ideally, we want the Data Explorer interface of Chronograf (1.2) with the option to export CSV data from query results. We had high hopes for this given that Chronograf already has a nicely formatted tabular view of Data Explorer results. But, unfortunately, no download feature exists.
- Is such a feature already in the Chronograf development pipeline? We haven’t been able to find this and have not yet submitted a request through the Github project.
- Is there another project “out there” that provides a similar interactive query building plus CSV export?
- Is there an approach linking together existing tools and TICK stack features that could provide what we’re looking for?
In the end, it seems what we’re interested in essentially already exists in pieces. So it seems we should be able to get this working. Any ideas very much appreciated.