After you start a data validation task, you can view the basic information, execution status, and results of the task on the task details page.
Go to the details page
Log in to the OceanBase Cloud console.
In the left-side navigation pane, select Data Services > Data Validation.
On the Data Validation page, click the name of the target data validation task to go to its details page and view its Basic Information and Details.
You can filter the target data validation tasks on the Data Validation page by type, source/target endpoint, status, cloud vendor, tag, task ID, or name. The operations supported for data validation tasks vary based on their status. For more information about how to view or modify the tags of a data validation task, see Manage data validation tasks by using tags.
Status Description Supported Operations Not Started Indicates that the data validation task has been configured but not started yet. Start, Clone, View Object, Modify Object, View Parameters, Modify Parameters, Release Running Indicates that the data validation task is running. Pause, Clone, View Object, View Parameters Paused Indicates that the data validation task has been paused. Resume, Clone, View Object, Modify Object, View Parameters, Modify Parameters, Release Failed Indicates that the data validation task has failed. Resume, Clone, View Object, Modify Object, View Parameters, Modify Parameters, Release Completed Indicates that the data validation task has completed and no errors occurred. Revalidate (only full validation and row count validation support this operation), Clone, View Object, Modify Object, View Parameters, Release
View basic information
The Basic Information section displays the basic information of the current data validation task.
| Parameter | Description |
|---|---|
| Connection Details | Click View after the connection details to view detailed information about the source and target cloud vendors, database types, instance types, and regions of the data validation task. |
| Task ID | The unique identifier for the data validation task. |
| Validation Type | The type of validation selected when creating the data validation task. |
| Created At | The time when the data validation task was created. |
| Billing Method | Currently, full validation tasks are free for a limited period. |
You can perform the following operations:
Start, pause, or resume a data validation task. For more information, see Start, pause, or resume a data validation task.
Restart validation
If the status is Completed and the validation type is either full validation or row count validation, you can click Restart Validation in the upper-right corner of the page to initiate a new data validation task for all validation objects.
View or modify validation objects
Click ... > View Objects in the upper-right corner of the page to view the list of validation objects for the current data validation task. You can also modify the validation objects if the status is Not Started, Paused, Failed, or Completed. For more information, see View and modify validation objects.
View or modify validation parameters
Click View Parameters or Modify Parameters in the upper-right corner of the page to view or modify the configuration parameters used when creating the data validation task. For more information, see View and modify validation parameters.
Clone a data validation task
Click ... > Clone in the upper-right corner of the page to clone the current data validation task. During cloning, you can modify the relevant configurations as needed. For more information, see Clone a data validation task.
Release a data validation task
If the status is Not Started, Paused, Failed, or Completed, you can click ... > Release in the upper-right corner of the page. For more information, see Release a data validation task.
View validation details
The Validation Details section displays the status and results of the pre-check tasks for the current task, as well as the status and results of the corresponding validation types.
Full validation
For full validation tasks, you can view the status and results of the task in the Validation Details section. You can also click Expand on the right to view information such as the start time, end time, RPS, and BPS.
The Validation Details section includes the Validation Objects and Validation Performance tabs.
On the Validation Objects tab, you can view the list of validation objects and perform corresponding operations.
For all validation objects, you can view information such as the source table, source database, target table, target database, status, and validation result.
You can filter by source database, target database, and validation result.
You can select View Completed Objects Only to view information about objects validated at the current time.
For tables with a validation result of Partially Mismatched, you can perform the following operations.
View inconsistent data: Click View in the Actions column. In the panel that appears, you can view details such as the type of inconsistency, field name, source value, and target value.
Revalidate data: Click Revalidate in the Actions column. In the dialog box that appears, select the validation scope as Entire Table or Only Mismatched Data, and then click Revalidate.
You can also select multiple tables with inconsistent data and click Revalidate at the bottom of the page to perform batch re-validation.
Correct inconsistent data: Click Edit in the Actions column. In the panel that appears, you can view the correction SQL statements. After confirming the corrections, click Apply Correction to Target. In the dialog box that appears, confirm the prompt and click OK.
For tables with a validation result of Other Errors, you can perform the following operations.
View inconsistent data: Click View in the Actions column. In the panel that appears, you can view details such as the type of inconsistency, field name, source value, and target value.
Resume the data validation task: Click Resume in the Actions column. In the dialog box that appears, confirm the prompt and click Resume.
You can also select multiple tables with other errors and click Resume at the bottom of the page to perform batch resumption.
Remove the validation object with errors: Click Remove in the Actions column. In the dialog box that appears, confirm the prompt and click Remove.
You can also select multiple tables with other errors and click Remove at the bottom of the page to perform batch removal.
For tables with a validation result of Not Supported, you can click Remove in the Actions column. In the dialog box that appears, confirm the prompt and click Remove.
You can also select multiple unsupported tables and click Remove at the bottom of the page to perform batch removal.
On the Validation Performance tab, you can view performance data such as Source RPS, Target RPS, Source Verification Traffic, and Target Verification Traffic in graphical form to effectively identify performance-related issues.
Row count validation
For row count validation tasks, you can view the status and results of the task in the Details section. You can also click Expand on the right to view information such as the start time and end time.
For all validated objects, you can view information such as the source table, source database, target table, target database, status, and validation result.
You can filter by source database, target database, and validation result.
For tables with a validation result of Partially Mismatched, you can click Revalidate in the Action column. After confirming the prompt in the dialog box, click Revalidate.
You can also select multiple tables with inconsistent data and click Revalidate at the bottom of the page to perform batch re-validation.
For tables with a validation result of Other Errors, you can perform the following actions:
Resume the data validation task: Click Resume in the Action column. After confirming the prompt in the dialog box, click Resume.
You can also select multiple tables with other errors and click Resume at the bottom of the page to perform batch resumption.
Remove the validated object with errors: Click Remove in the Action column. After confirming the prompt in the dialog box, click Remove.
You can also select multiple tables with other errors and click Remove at the bottom of the page to perform batch removal.
For tables with a validation result of Not supported, you can click Remove in the Action column. After confirming the prompt in the dialog box, click Remove.
You can also select multiple unsupported tables and click Remove at the bottom of the page to perform batch removal.