Tips for maintaining many-to-one relationships across multiple tables

Synthetic Data Creation
1

@giovanni.circo could you please add a short description of the challenges you’re facing?

2

SDV synthesizers are able to handle one-to-many relationships by default. Make sure that the primary and foreign key connection is listed in your metadata and watch SDV do the rest!

SDV Guarantee

SDV guarantees referential integrity, meaning that all the foreign keys will reference a known primary key – no missing links/broken references.

In a one-to-many relationship, the cardinality refers to the number of connections between a parent and child. For example, each row of the parent table may be referenced by 0 or more rows in the child table. The SDV synthesizers are also set up to learn:

  • The min cardinality (eg. each parent row must be referenced by at least 1 child row)
  • The max cardinality (eg. each parent rows must be referenced by at most 5 child rows)
  • The distribution in between (eg. most parent rows are referenced by 2 children)

Measure the SDV guarantee using the Diagnostic Report and let us know if you have any feedback!