7. Workspace synchronization & validation

Before generating synthetic data, Syntho performs automated checks to ensure your workspace aligns with the schemas of your source and destination databases. This ensures compatibility, preserves referential integrity, and prevents generation failures.

Interactive guide: How to validate a workspace

Follow the interactive guide below to validate a workspace

Source schema validation

Your source database schema may evolve over time—tables may be added, columns removed, or data types changed. Syntho automatically detects such changes during generation and warns you if your workspace is out of sync.

Automatically detected changes

Syntho will detect and synchronize:

Table-level changes: primary key updates, constraint modifications, table removal
Column-level changes: type changes, nullable status, constraints, or key assignments

Unresolved schema mismatches may result in job failure, so it’s best practice to sync regularly.

Destination schema validation

Syntho also validates your destination schema to ensure it is ready to receive the generated synthetic data. Issues here can block the generation process or result in incorrect output.

Table-level issues (blocking)

Table does not exist
Primary or foreign key mismatch with source

Resolution

Ensure table structure matches the source schema. Remove or align keys as needed.

Table-level warnings (non-blocking)

Table already contains data → Truncate the table in the destination
Table is part of a circular reference → Disable foreign key constraints temporarily