7. Workspace synchronization & validation
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
Follow the interactive guide below to validate a workspace
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.
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.
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 does not exist
Primary or foreign key mismatch with source
Ensure table structure matches the source schema. Remove or align keys as needed.
Table already contains data → Truncate the table in the destination
Table is part of a circular reference → Disable foreign key constraints temporarily
Missing columns
Extra non-nullable columns without defaults
Not-nullable columns not present in the source
Adjust column definitions to match source schema exactly.
Data type mismatches
Unexpected uniqueness or check constraints
Missing default values
Column length or max value is lower than source
Align data types, constraints, and value limits between source and destination columns.
After resolving all validation issues and confirming schema synchronization, you can safely proceed to generate synthetic data.