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

Add verify timestamp as a new field in InfluxDB measurements

    XMLWordPrintable

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: squash
    • Labels:
      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

            Hide
            afausti Angelo Fausti added a comment -
            Show
            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

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

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.