Search code examples
timestampgrafanavertica

How can I convert string timestamp column to timestamp in grafana

I'm using PG plugin for vertica in grafana because grafana don't have native Vertica plugin

select date_trunc('hour', moment) as time,
       sum(netSlaes)              as netSales
from ba.table
group by time;

Grafana tells that:

Invalid type for column time, must be of type timestamp or unix timestamp, got: string 2019-05-28 22:00:00

But when I use DataGrip this sql returns:

2019-05-28 05:00:00.000000  1456106.03030303
2019-05-28 11:00:00.000000  16463313.9090909
2019-05-28 13:00:00.000000  15796558.4818182
2019-05-28 14:00:00.000000  5134891.6969697
2019-05-28 20:00:00.000000  13058329.5909091
...

Please help with timestamp format for time column

Solution

  • vertica developers added their plugin for grafana: https://grafana.com/grafana/plugins/vertica-grafana-datasource/installation

    about 4 months ago