Run the Data Reconciliation Recipe

Compare an asset with a reference asset, resolve every mismatch, and write the keep and remove sets to your enrichment destination, from the Recipes page to the Complete step. For what each step does and why, see Build and Validate and Scan and Reconcile.

Steps

Step 1: Navigate to the Recipes page by clicking Recipes on the left side panel.

Step 2: On the Data Reconciliation card, click Get Started. The recipe opens on the Select Assets step.

Step 3: In the Left column, select the Datastore and the asset to inspect. In the Right column, select the reference datastore and asset. Check the Schema overlap panel, then click Next.

Step 4: On Row Identifiers, click Apply all to accept the suggestion, or click Add identifier and pick the shared field that identifies a row on both sides. Click Next.

Step 5: On Compare Fields, click Apply all to accept the suggestion, or tick the fields that must agree and leave the others under Passthrough. Click Next.

Step 6: On Tolerances, keep or adjust the Differences to detect and set the Comparators for the field types you compare. Click Next.

Step 7: On Review, confirm the configuration. Click any card to go back and change it. Click Next. The recipe creates the check as a Draft and opens Validate.

Step 8: Click Validate. When the step confirms Reconciliation check validated, click Scan & Reconcile.

Step 9: On Scan, click Scan and wait for the full scan to finish. If the step asks you to link an enrichment destination first, see Link an Enrichment Destination from the Scan Step. Review the results, then click Next. If the scan found no mismatches, click Complete.

Step 10: On Reconcile, pick a side for each mismatch in the Choose column, working through the Changed, Added, and Removed tabs. To let AgentQ propose them, click Get AI suggestions and then accept them per row or with Accept AI suggested resolutions. When every mismatch is resolved, click Next.

Step 11: On Materialize, check the output names and the Preview, then click Materialize. When it finishes, the recipe moves to the Complete step. If every pick kept the left asset as it is, click Complete instead.

Step 12: The Complete step confirms Data Reconciliation Completed. Use the cards under Everything this run produced to open the keep set, the remove set, the check, the anomaly, and the scan.