SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.

SigNoz Community

Hi,
I wanted to explore logs with Grafana log explorer but the clickhouse plugin requires a TimeField of type datetime to be auto detected.
any idea why you are using ``timestamp` *UInt64* CODEC(DoubleDelta, LZ4),` and not datetime ?

You can convert the epoch to datetime in ClickHouse using functions like `toDateTime`

yes for custom queries, but wanted to use it in grafana Log Explore, cf this: <https://github.com/grafana/clickhouse-datasource/issues/420|https://github.com/grafana/clickhouse-datasource/issues/420>