I recently built something similar. I have a web app which logs json data to a file. Then I use vector.dev to tail the file. Vector has a clickhouse integration

I recently built something similar. I have a web app which logs json data to a file. Then I use vector.dev to tail the file. Vector has a clickhouse integration so it automatically pushes logs into the DB. I also have it automatically push data to S3 as a backup. The system works remarkably well!