Hi guys ! I would like to have some advice. I'm exporting some metrics with this conf :

receivers:  
  httpcheck: # <https://signoz.io/blog/health-check-monitoring-with-opentelemetry/>
    collection_interval: 30s
    targets:
      - endpoint: "https://<ip_server>/healthcheck"
        method: GET
        tls:
          insecure_skip_verify: true
...
exporters:
  clickhousemetricswrite:
    endpoint: tcp://<signoz_serveur>:9000/signoz_metrics?username=u&password=p
    tls:
      insecure: true
    resource_to_telemetry_conversion:
      enabled: true

Then on the dashboard I use PromQL to build a new "Panel" (I call that widget). Isn't better to build the query directly with a SQL request on ClickHouse ? If so, I don't find documentations about the tables ?

SHOW TABLES FROM signoz_metrics;

    ┌─name───────────────────────────────────┐
 1. │ distributed_exp_hist                   │
 2. │ distributed_metadata                   │
 3. │ distributed_samples_v2                 │
 4. │ distributed_samples_v4                 │
 5. │ distributed_samples_v4_agg_30m         │
 6. │ distributed_samples_v4_agg_5m          │
 7. │ distributed_schema_migrations_v2       │
 8. │ distributed_time_series_v2             │
 9. │ distributed_time_series_v4             │
10. │ distributed_time_series_v4_1day        │
11. │ distributed_time_series_v4_1week       │
12. │ distributed_time_series_v4_6hrs        │
13. │ distributed_updated_metadata           │
14. │ distributed_usage                      │
15. │ exp_hist                               │
16. │ metadata                               │
17. │ samples_v2                             │
18. │ samples_v4                             │
19. │ samples_v4_agg_30m                     │
20. │ samples_v4_agg_30m_mv                  │
21. │ samples_v4_agg_5m                      │
22. │ samples_v4_agg_5m_mv                   │
23. │ schema_migrations_v2                   │
24. │ time_series_v2                         │
25. │ time_series_v4                         │
26. │ time_series_v4_1day                    │
27. │ time_series_v4_1day_mv                 │
28. │ time_series_v4_1day_mv_separate_attrs  │
29. │ time_series_v4_1week                   │
30. │ time_series_v4_1week_mv                │
31. │ time_series_v4_1week_mv_separate_attrs │
32. │ time_series_v4_6hrs                    │
33. │ time_series_v4_6hrs_mv                 │
34. │ time_series_v4_6hrs_mv_separate_attrs  │
35. │ updated_metadata                       │
36. │ usage                                  │
    └────────────────────────────────────────┘

Right now the PromQL query looks like this :

max(   (last_over_time(httpcheck_status{health_score="3", service_name="PASSPORT", vm_hostname="3dx-dev08"}[5m]) * 3) or   (last_over_time(httpcheck_status{health_score="2", service_name="PASSPORT", vm_hostname="3dx-dev08"}[5m]) * 2) or   (last_over_time(httpcheck_status{health_score="1", service_name="PASSPORT", vm_hostname="3dx-dev08"}[5m]) * 1) )

How do I know which table this query ? WHere the data come from ?

This should help you https://signoz.io/docs/userguide/write-a-metrics-clickhouse-query/

Hi @nitya-signoz TY, I will proof read this. Also I find weird data with the config have write here. I don't know if this come from the collector or signoz. Who can I talk to about this issue ?