❖ CarryOverColumns

❖ 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 CarryOverColumns CAG Pattern when you have the same columns in a parent table and a child table, and the values of those columns have to match up according to the connection.

The 'Type' column is carried over.

Pattern API

This functionality is in Beta. At this time, select SDV Enterprise users have been invited to use this feature.

Create a CarryOverColumns pattern object

Parameters:

• (required) parent_table_name: A string with the name of the parent table in the relationship

• (required) child_table_name: A string with the name of the child table in the relationship

• (required) child_foreign_key: A string with the name of the foreign key column in the child.

• (required) column_map: A dictionary with the name of the column in the parent table (key) with the name of the column in the child table (value) that is copied over.

from sdv.cag import CarryOverColumns

my_pattern = CarryOverColumns(
    parent_table_name='Accounts',
    child_table_name='Transactions',
    child_foreign_key='Account ID',
    column_map={
        'Type': 'Type'
    })

Make sure that all the tables in you provide are in your Metadata, as well as the relationship between the primary and foreign key.

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()