Verifying a Clone
After a clone, you can run a verification to confirm that the target project matches the source project.
Why Verify?
A clone can have minor discrepancies:
- Writes to the source project during cloning
- Components that failed silently
- Differences in versions or extensions
Verification gives you a clear view of the actual state.
Running a Verification
- Go to Dashboard > Clones > [your clone] > Results
- Click Verify
- The verification runs (typically 10 to 30 seconds)
- The report appears
What Is Verified
Schema
- Do the source tables exist in the target?
- Do the columns match (name, type, nullable, default)?
- Are the constraints identical (PK, FK, unique, check)?
- Are the indexes present?
Data
- The row count per table is compared between source and target
- Significant discrepancies are flagged
Missing Objects
- Functions, views, or triggers present in the source but missing from the target
- RLS policies that were not applied
Verification Results
| Result | Meaning |
|---|---|
| Passed | Everything matches — the target conforms to the source |
| Warning | Minor discrepancies (e.g., slight row count differences due to concurrent writes) |
| Failed | Significant discrepancies — objects are missing or data does not match |
| Not run | The verification has not been run yet |
Interpreting the Results
Small Row Differences
Differences of a few percent are normal if the source project receives writes during the clone. This is not a problem.
Missing Tables
If a source table does not exist in the target, it means the creation failed during the clone. Check the clone report for the error.
Missing Columns
If a table exists on both sides but columns are missing in the target, you can re-run a clone — the missing columns will be added automatically.
What to Do If Verification Fails?
- Review the report to identify the discrepancies
- Re-run a clone — the process is designed to be idempotent
- If the problem persists, check the extensions and permissions on the target project
- You can also restore from a backup if you have one
Next Steps
- Restoring a Backup — In case of issues
- Components — Details on what is verified