Hi all 👋 Happily paying for the hosted version but we have a question: we have some Clickhouse queries (mostly from traces) we'd like to run cron-style (daily, weekly) and get them out of Signoz (e.g. Slack, Mail, API). Is there any way to do so currently? Completely open for creative ideas to solve this.

Hello, This is not possible within the SigNoz at the moment. You will have the ability to create an API token and access the relevant APIs. You can try running the cron script on your side till the support for this reporting feature.

Thanks a lot for the blazing fast answer! Is https://signoz.io/api_reference/ the right place to look for the documentation? I can see that the dashboard configuration/query/layout can be fetched via the API but somehow I'm missing the actual data that is being used to render the dashboards? Am I wrong? Which API would let me run the Clickhouse SQL queries? 🤠

The relevant OpenAPI reference doesn't exist yet. You would have to use

query_range

API. When you load a dashboard, you can see the

/query_range

XHR requests in DevTools network tab. Do you already have some panels with ClickHouse queries?

Thanks a lot! POSTed my few first queries from already present dashboards and had success provoking a 504, poor, poor Clickhouse instance churning the data... I would call it a complete success! 😎 Thanks a lot once more for the quick and on point answers 🎯 👍 Btw: Each and every contact with you is really up to high standards, keep up the good work 💪