How to visualise timescaledb metrics stored in an SQL jsonb datatype

Grafana
#1

In timescaledb i have metrics stored in jsonb datatype.
How do I parse and visualize with grafana.

#2

Manual writing an sql query which first presents good as a table.

  1. Using the ‘->’ operator to extract the values.
  2. Converting these values to ::NUMERIC type solved the problem.