Import CSV Files to ClickHouse

Fast, parallel file import using DuckDBStream

Source

CSV

.csv files

FastTransfer

DuckDBStream

Target

ClickHouse

Terminal

FastTransfer.exe `
  --sourceconnectiontype "duckdbstream" `
  --sourceserver ":memory:" `
  --query "SELECT * FROM read_csv('D:\path\to\files\*.*.csv', filename=true)" `
  --targetconnectiontype "clickhouse" `
  --targetserver "your-server" `
  --targetdatabase "your-database" `
  --targettable "your-table" `
  --method "DataDriven" `
  --distributekeycolumn "filename"  `
  --datadrivenquery "select file from glob('D:\path\to\files\*.csv')"  `
  --degree -2  `
  --loadmode "Truncate"  `
  --mapmethod "Name"

Related Pipelines

✨ Key Features

•Parallel file processing with DuckDBStream
•Streaming architecture - minimal memory usage
•Wildcard pattern support for multiple files
•Automatic schema detection

🚀 Performance

•DataDriven parallelization
•Configurable degree of parallelism
•Optimized bulk loading
•Production-ready reliability