It will probably be even faster: > clickhouse-client --time --query "INSERT INTO rides FROM INFILE 'nyc_data_rides.csv' FORMAT CSV;"