You should be able to get the query results but with some hit to performance. ClickHouse keeps a metadata for s3 objects on the disk and fetches info when needed.
SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.