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

Column-level issues (blocking)

• Missing columns

• Extra non-nullable columns without defaults

• Not-nullable columns not present in the source

Resolution

Adjust column definitions to match source schema exactly.

Column-level warnings (non-blocking)

• Data type mismatches

• Unexpected uniqueness or check constraints

• Missing default values

• Column length or max value is lower than source

Resolution

Align data types, constraints, and value limits between source and destination columns.

---

Final step: generate

After resolving all validation issues and confirming schema synchronization, you can safely proceed to generate synthetic data.