Create a data validation task

Go to the Create Data Validation Task page.

1. Log in to the OceanBase Cloud console.

2. In the left-side navigation pane, select Data Services > Data Validation.

3. On the Data Validation page, click Create Task in the upper-right corner.

Enter a custom name for the validation task in the Edit Task Name field.

We recommend that you use a combination of letters, numbers, and Chinese characters. The name cannot contain spaces and must be no longer than 64 characters.

In the Configure Source & Target step, configure the parameters in the Source section.

If you want to reference an existing data source, click Quick Fill next to Source and select the desired data source from the drop-down list. The configurations in the Source section will be automatically filled in. If you want to save the current configuration as a new data source, click the Save icon in the upper-right corner of the Source section.

You can also click Manage Data Sources in the Quick Fill drop-down list to go to the Data Sources page, where you can view and manage data sources. This page provides unified management for different types of data sources. For more information, see Data Sources module.

In the Configure Source & Target step, configure the parameters in the Target section.

If you need to reference an existing data source, click Quick Fill on the right side of Target, and select the target data source from the drop-down list. After you select a data source, the configuration parameters in the Target section will be automatically filled in. If you want to save the current configuration as a new data source, click Save in the upper-right corner of the Target section.

You can also click Manage Data Sources in the Quick Fill drop-down list to go to the Data Sources page, where you can view and manage data sources. This page allows you to manage data sources of different types. For more information, see the Data Sources module.

Click Test and Continue.

In the Select Type & Objects step, select the validation type for the current data validation task.

Currently, you can select Full Validation or Row Count Validation. For more information, see Overview of data validation.

In the Validation Objects section, choose the method for selecting validation objects.

You can select validation objects by using Specify Objects or Match by Rule.

In the Select Objects section, select the object to be validated.

• If you select Specify Objects. In the left pane, select the table objects to be validated and click > to add them to the right pane.

  Data validation supports importing objects through text and allows renaming target objects, setting row filters, viewing column information, and removing individual or all validation objects.

  Action	Description
  Import Objects	In the right pane of the selection area, click Import in the upper-right corner. For more information, see Import validation objects.
  Rename	Data validation allows renaming validation objects. For more information, see Rename validation objects.
  Row Filter	Full Validation supports WHERE conditions for row filtering. For more information, see SQL condition filtering for validation objects. You can also view column information of validation objects in the View Column area.
  Remove/Clear All	Data validation allows removing temporarily selected objects to the target during data mapping. Remove a single migration object Click the Remove icon next to the target object in the right pane of the selection area to remove it. Remove all migration objects Click Clear All in the upper-right corner of the right pane of the selection area. In the dialog box that appears, click OK to remove all migration objects.

• If you select Match by Rule. For more information, see Configure matching rules for validation objects.

Click Next. In the Validation Options step, configure the parameters.

• Full validation

  In the Select Type & Objects step, select Full Validation to display the following parameters.

  Parameter	Description
  Source Concurrency/Target Concurrency	The minimum value is 1 and the maximum value is 512. The default value is 4.
  Validation Mode	Valid values: Adaptive and IN Mode. Adaptive: Data is fetched in batches from the source and target, and then compared precisely. IN Mode: Data is fetched in batches from the source. Based on the unique keys of the target data, an IN condition query is performed on the target to compare whether the data is consistent. Note that this mode cannot validate scenarios where the target contains data not present in the source. Additionally, the performance of this mode may degrade. We recommend using this mode only when the target contains unexpected extra data that does not need to be validated or in migration scenarios involving database table aggregation.
  Limit BPS	The unit is MiB/s, and the maximum value is 1024. If you enable this option, please set at least one of the minimum rates for the source or the target.

• Row count validation

  In the Select Type & Objects step, select Row Count Validation to display the following parameters.

  Parameter	Description
  Concurrent Tables for Validation	The minimum value is 1, the maximum value is 100, and the default value is 10. This configuration applies to both the source and the target.
  Query Timeout	The unit is minutes. The minimum value is 1, the maximum value is 1440, and the default value is 10. This configuration applies to both the source and the target.

Click Next to perform a pre-check on the data validation task.

After the pre-check is successful, click Start Task.

If you do not need to start the task immediately, click Save to go to the details page of the data validation task, where you can manually start the task as needed. For more information, see View details of a data validation task.