Skip to main content

Data Filtering

Overview​

CloudCanal supports data filtering for Incremental DataJobs to address different scenarios and requirements.

This article introduces how to create a DataJob with data filtering using MySQL to MySQL synchronization as an example.

Steps​

  • Log in the CloudCanal console.

  • Select the source and target DataSource,click Next Step.

  • Configure the DataJob settings, click Next Step.

  • Select the tables to be synchronized and filter actions.

  • Select the tables which you want to set data filtering conditions and click Operation > Data Filtering. 2.png

  • Input the correct WHERE Condition by filling in the content after the WHERE keyword. 1.png

  • Click on Create DataJob to successfully create the data filtering DataJob. 3.png