Metrics SQL queries

SELECT
  name as name,
  CASE
    WHEN gauge.value IS NOT NULL THEN 'gauge'
    WHEN counter.value IS NOT NULL THEN 'counter'
    WHEN histogram IS NOT NULL THEN 'histogram'
    WHEN summary IS NOT NULL THEN 'summary'
    ELSE 'unknown'
  END as metric_type,
-- any(tags) as tags
FROM {{source}}
GROUP BY name, metric_type