Hi I am trying to run it with using clickhouse database in cloud.I am using dockerfordesktop for deployment. somehow it is always looking for sqllite database

I believe Clickhouse is just for the mass OTel storage, but the UI itself uses SQLite for dash, alerts, settings. This question has come up a lot lately. https://github.com/SigNoz/signoz/issues/941