Feature: Dashboard ClickHouse query
Query 1:
```SE...
# supportd
Dang Huy Nguyen
08/01/2025, 6:02 AMFeature: Dashboard ClickHouse query
Query 1:
Copy code
SELECT resource_fingerprint
FROM signoz_traces.distributed_signoz_index_v3 Copy code
SELECT resources_string
FROM signoz_traces.distributed_signoz_index_v3h
Hien Le
08/01/2025, 5:03 PMJust needs a slight tweak from what you had:
Copy code
SELECT resources_string['deployment.environment']
FROM signoz_traces.distributed_signoz_index_v3 limit 100;d
Dang Huy Nguyen
08/04/2025, 4:05 AMHi @Hien Le, thanks for your response. I tried it before but it does not return correct result. Btw have you used SigNoz on production?
How it's going? I tried to adopt but seems it's still quite buggy.
Dang Huy Nguyen
08/04/2025, 4:22 AMI only care 3 features:
1. Fast trace/logs query
2. SQL explorer, where I can slide and dice my telemetry
3. Application performance monitoring
SigNoz seems good at 1 only, I tried query builder for 3 but does also got unexpected behavior
h
Hien Le
08/04/2025, 4:12 PMI haven't tried much of 2 or 3 since it seems every backend has its own way of storing metrics / traces and writing queries by hand can get complicated. What slicing / dicing are you attempting that's not possible with the built-in query builder?
Hien Le
08/04/2025, 4:36 PMI think the reason
limit 100resource_stringtimestamp2 Views