Hi team quick question, I am trying to connect my clickhouse service from signoz to grafana as a data source and I don't want to use the default clickhouse username and password. Is it possible to create a grafana username and password that doesn't have all admin privileges? Would appreciate your help with this and how it can be implemented.

Hey @Anthony Akoji Any reason why you want to use grafana rather than SigNoz? Are their any usecases which SigNoz can't solve?

I am currently using SigNoz, and we are looking for a way to query data from our ClickHouse database, which is installed on a cluster. To avoid multiple users accessing the pod directly, we are considering exposing the database to a tool like Metabase. However, we want to avoid using the root username and password due to their admin privileges. Instead, we plan to create a new user with only SELECT privileges. so from the values yaml i see the clickhouse user and password but is it possible to create another user ?https://github.com/SigNoz/charts/blob/main/charts/signoz/values.yaml#L116

You should be able to connect to clickhouse and experiment with that - https://signoz.io/docs/operate/clickhouse/connect-to-clickhouse/ With latest version of SigNoz self hosted you can access your data with API keys - https://signoz.io/blog/open-source-signoz-now-available-with-sso-and-api-keys/