SELECT $__timeGroup(DATETIME,$__interval) as Time, HOST as metric, (max(USED/1024*1024)/max(TOTAL/1024*1024)*100) AS used_percent FROM SERVER_MEMORY WHERE $__timeFilter(DATETIMEUTC,$__interval) AND SERVICE='service1' GROUP BY 1,2 ORDER BY 1
Using mysql
Where as using snowflake plugin
Expected result: We should see a separate column for each HOST(metric) in a given time series
Grafana Version: 9.1.1
Executed Query:
SELECT $__timeGroup(DATETIME,$__interval) as Time, HOST as metric, (max(USED/1024*1024)/max(TOTAL/1024*1024)*100) AS used_percent FROM SERVER_MEMORY WHERE $__timeFilter(DATETIMEUTC,$__interval) AND SERVICE='service1' GROUP BY 1,2 ORDER BY 1Using mysql
Where as using snowflake plugin
Expected result: We should see a separate column for each HOST(metric) in a given time series