❖ UniqueBridgeTable

❖ SDV Enterprise bundle. This feature is available for purchase as an SDV Enterprise bundle. For more information, visit our page to Explore SDV.

Use the UniqueBridgeTable CAG Pattern when you have a bridge table that records a many-to-many relationship between multiple tables, and the connections have to be unique. That is to say, the combinations of keys in the bridge tables must be unique.

The Author-Book table records unique links between Authors and Books.

Pattern API

Create a UniqueBridgeTable pattern object.

Parameters:

• (required) table_name: A string with the name of the bridge table

• (required) foreign_key_columns: A list of strings with the names of the foreign key columns. The combination of values in these columns must be unique.

from sdv.cag import UniqueBridgeTable

my_pattern = UniqueBridgeTable(
    table_name='Author-Book',
    foreign_key_columns=['Author ID', 'Book ID'])

Make sure that all the tables and columns you provide are listed in your Metadata, as well as all foreign key connections.

Usage

Apply the pattern to any SDV synthesizer. Then fit and sample as usual.

synthesizer = HSASynthesizer(metadata)
synthesizer.add_cag(patterns=[my_pattern])

synthesizer.fit(data)
synthetic_data = synthesizer.sample()