Overview
Initial load is the first phase of a CDC ClickPipe, where the ClickPipe syncs the historical data of the tables in the source database over to ClickHouse, before then starting CDC. A lot of the times, developers do this in a single-threaded manner. However, the MySQL ClickPipe can parallelize this process, which can significantly speed up the initial load.Partition key column
You can see the below setting in the ClickPipe table picker (both during creation and editing of a ClickPipe):
Logical partitioning
Let’s talk about the below settings: