Configuring Schema Validation

The Schema validation stage validates whether the schema of the table in the source database matches the schema of the corresponding table in the target database. It validates the tables, columns, data types, and numeric precision across all tables within the source and target data sources, which ensures schema compatibility and facilitates efficient data transfer.

To configure the Schema validation, follow the below steps:

In Validation Type, select Schema to validate the tables, columns, data types, and numeric precision across all tables within the source and target data sources.

In Source Data, select the input data for validation.
In Target Data, select the target data for validation.

In Config File, upload the configuration file that instructs the system what to validate within the complete dataset.
To automatically synchronize the source and target data sources, turn on the Sync Schema toggle.
Click Save to save the Validation stage. The system displays an alerting snackbar pop-up to notify the success message when the Validation stage is successfully saved.

Click to execute the pipeline. The pipeline listing page opens and displays the pipeline status as Running. When execution is successfully completed, the status changes to Success.
Click the pipeline card to see reports.

To view the Schema Validation Stage report, visit Schema Validation Report.