In the past I used clickhouse-bulk and the buffer engine, mostly, which did a good job indeed.

However, during the last years I always find myself using https://vector.dev/ for all sort of tasks, including bulk inserts in ClickHouse.