clickhouse-grafana

clickhouse-grafana copied to clipboard

I've found could be useful to have data tables as dataframes in Grafana.

by example in this case could be fine if we can transform this table.

┌─t─┬─cat─┬─errors─┐
│ 1 │   3 │     24 │
│ 1 │   4 │     84 │
└───┴─────┴────────┘

in this other ( grafana dataframe ready to handle transformations) .

+---------------------+-----------------+-----------------+
| Name: time          | Name: errors    | Name: errors    |
| Labels:             | Labels: cat=3   | Labels: cat=4   |
| Type: []time.Time   | Type: []float64 | Type: []float64 |
+---------------------+-----------------+-----------------+
| 1                   | 24              | 84              |
+---------------------+-----------------+-----------------+

 I'm newbie in clickhouse, but after some days working with clickhouse  plugin 2.3.2 data and grafana 7.5.5 , I didn't found any solution for this.
There is any way to do that?  (special column naming may be?) 

Thank you very much for your patience

need to create ./docker/grafana/dashboards/issue_404_tranformation_table.json where table default.test_grafana

SELECT service, count() AS value 
FROM $table

or

$columns(service, count() AS value) 
FROM $table

format As Table and use transformation to transpose rows to columns in Grafana