Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-17049

Add verify timestamp as a new field in InfluxDB measurements

    XMLWordPrintable

Details

    • Story
    • Status: Done
    • Resolution: Done
    • None
    • squash
    • None

    Description

      I was trying to add to the SQuaSH dashboards a single stat showing the time of the last validate_drp measurement - it turns out that stats visualization does not display timestamps, only numbers, and it is not possible to do math on timestamps in InfluxQL to get say "number of days without measurements"

      https://github.com/influxdata/docs.influxdata.com/blob/master/content/influxdb/v0.13/troubleshooting/frequently_encountered_issues.md#doing-math-on-timestamps

      So I think it is a good idea to add the timestamp of the measurement as a new field, as we did for the EFD topics, there that information was useful to report on things like latency for instance.

      Attachments

        Issue Links

          Activity

            afausti Angelo Fausti added a comment - Timestamps are now added as an InfluxDB field as well. https://github.com/lsst-sqre/squash-restful-api/blob/master/examples/influxdb_data_model.ipynb

            People

              afausti Angelo Fausti
              afausti Angelo Fausti
              Angelo Fausti
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Jenkins

                  No builds found.