ClickHouse can export data directly into compressed files, just write SELECT * FROM tutorial.kttm INTO OUTFILE 'data.json.gz' FORMAT JSONEachRow; gz, bz2, xz,

ClickHouse can export data directly into compressed files, just write SELECT * FROM tutorial.kttm INTO OUTFILE 'data.json.gz' FORMAT JSONEachRow; gz, bz2, xz, zstd, lz4 - all supported.