Limitations

When using AI synthesis, it is always required to prepare your data into a single entity table. This gives the highest utility. You can consider preparing the data into an SQL view.

When working with multiple related tables, AI synthesis is no solution, and it's advisable to use mock and mask generators, and calculated columns. If cross-table logic is important, first consider reshaping the source into a single entity table or SQL view. If that is not feasible, use de-identification instead of AI synthesis.

Approach	Table limit	Cross-table correlations	Consistency	Capture business rules
AI synthesize	1 feature table
Mock	Unlimited
Mask	Unlimited
Calculated columns	Unlimited