Visuale temporal API data with Grafana about tutorials.short-term-history HOT 1 OPEN

Okay I think I got it - There will be used different databases for different tenants in postgres. So relevant data from farm tutorial will be in database ngb<tenant-name> instead of database ngb. So I have been able to find all relevant data in database names 'ngbopeniot'.

There you can find all temporal data in the two tables temporalentity and temporalentityattrinstance in case of Scorpio.

In order to visualize your data with Grafana you will need to:

1. connect to correct tenant db (here: nbgopeniot)
2. Perform a query where you
   • Select observedat, temporalentity_id and value
   • Filter by kind of entites you want to visualize (here for example pig014 and only non-empty values)

   SELECT
     observedat AS "time",
     temporalentity_id AS metric,
     value
   FROM temporalentityattrinstance
   WHERE
     $__timeFilter(observedat) AND
     temporalentity_id = 'urn:ngsi-ld:Animal:pig014' AND
     value = value
   ORDER BY 1,2
   

3. Add a transformation to the query so that the value field will be converted to a numeric field (otherwise this field is String by default and can't be visualized by Grafana as a graph [just table])

I attached a successful screenshot for pig014.

Just as a suggestion to also help others: Maybe you can add to documentation / tutorial how I can visualize STH data in Grafana in the future as well - I needed quite a long time to figure that out (I asked the question initially at stack overflow 3 months ago with no answer so far https://stackoverflow.com/questions/72995260/question-on-visualization-of-fiware-sth-data-with-grafana).

from tutorials.short-term-history.