This timeout issue may also be caused by the "Connection Idle Timeout" set in the load balancer. The clickhouse-connect python library (v0.8.18) doesn't have a mechanism to keep the connection out of the "idle" state.
clickhouse-connect