MOSTLY AI analyzed the database’s schema and configured the database’s relationships on the basis of the subject table classification you provided in Step 5. During this analysis, MOSTLY AI distinguished between two types of relationships:

  • Relationships that are critical for privacy security and synthetic data accuracy.
    MOSTLY AI classifies these as Context foreign key relationships.

  • Relationships that are necessary for maintaining referential integrity.
    MOSTLY AI classifies these as Smart Select foreign key relationships.

In the Column details tab, you can review how MOSTLY AI classified the database’s relationships and optionally configure how the Smart Select relationships will be rendered.

By default, the entries in the parent and child tables of a Smart Select relationship will be randomly linked. That is to say, the foreign key column will be populated with randomly drawn ID’s from the primary key.

You can change this behavior by designating one or more columns of the parent table in a relationship as Smart Select columns. MOSTLY AI can then use these attributes to find appropriate matches with the entries in the child table of a relationship. This will result in a more accurate rendering of these relationships in the resulting synthetic database.

These are two ways to designate Smart Select columns:

  • Using the Smart Select columns section in a subject table’s Column details view
    Here you can configure a subject table’s multiple referring tables at once.
    Read more in the respective section on this page.

  • Using the column parameters of a Smart Select foreign key column.
    Here you can configure parent-child table relationships where the parent is not a subject table.
    Read more in the respective section section on this page.

To decide which method best suits your database, please review how MOSTLY AI preconfigured the relationships. Whenever you find a linked table with a Smart Select foreign key pointing to another linked table, then you can only configure this relationship using the Column parameters of that Smart Select foreign key column. Read on to learn how to review these relationships.

Reviewing the preconfigured relationships

The Column details tab is divided into two panes. The left pane lists the tables you selected in Step 5. The right pane shows the details about the role a given table has in the dataset and its relation to the other tables. Here, you can also configure its training parameters and access column level job settings, such as the generation method, encoding type, and encoding options.


Column details overview


Left pane

Here you can select the table that you want to configure. Each subject table in this list has a Subject indicator next to its name.

Right pane - top section

This section shows the table name, its role in the database, to which root table it belongs, and its number of foreign keys.

Right pane - middle section

Here you find the column list for the selected table. You can learn which Generation method MOSTLY AI assigned to each column, exclude columns from the resulting synthetic database by toggling the Include switch to the left, or configure the generation method by clicking the settings icon.

Right pane - bottom section

In this section, you can configure the training parameters for the selected table. If you selected a subject table, then you can also select the Smart Select columns that guide MOSTLY AI in finding appropriate matches between the entries in this table and its referring tables.

To determine which linked tables have Smart Select foreign keys that point to other linked tables, click through all linked tables in the Table list and check whether you can find such a foreign key in the column list. A column with these characteristics would have Smart Select foreign key → [name of another linked table] as its Generation method.

Configuring Smart Select relationships using the Smart Select columns section

Subject tables have a Smart Select columns section in their Column details view. It simplifies the configuration process by allowing you to configure all relationships between the selected subject table and its referring tables at once.

By following the steps below, you designate one or more columns of the selected subject table as Smart Select columns and immediately apply this configuration to the Smart Select foreign keys of the referring tables. This will save you a lot of effort in configuring each relationship individually.

  1. Select a subject table from the table list in the left pane.

    Job settings


  2. Scroll down until you see the Smart Select columns section and click on Edit configuration.

    Job settings


  3. A modal appears where you can choose which columns of the selected subject table are to be used as Smart Select columns. Each column you add will improve the accuracy with which MOSTLY AI can match the entries in this table and its referring tables.

    Job settings


  4. Next, you can rank the selected Smart Select columns by order of importance by dragging them up or down. This will further improve the accuracy with which the relationship is rendered.


  5. Once you have completed the configuration, click Apply to referring tables. It will then be applied to the Smart Select foreign keys of the referring tables.

    If you configured some Smart Select foreign keys using the Column parameters of the referring tables, you might want to click Apply to unmodified referring tables instead. The configuration that you created will then only be applied to the remaining Smart Select foreign keys.


  6. If you want to verify whether your Smart Select configuration is applied to the referring tables, select one of them from the Table list and follow the steps in the section below.


Configuring Smart Select relationships using the Column parameters

You can also configure the Smart Select columns directly in the Column parameters of a Smart Select foreign key column. This will allow you to configure relationships that don’t have a subject table as a parent.

  1. Select a linked table from the table list in the left pane.

    Job settings


  2. To access the Column parameters of a Smart Select foreign key column, locate the column in the list of columns and click on the settings icon. The Generation method indicates whether a column is a Smart Select foreign key and to which parent tables it’s linked.

    Job settings


  3. A modal appears where you can choose the Smart Select columns. If you click on + Add new column, you will see that these are the columns of the parent table. Each column you add will improve the accuracy with which MOSTLY AI can match the entries in this table and its parent table.

    Job settings


  4. Click OK to confirm your Smart Select configuration.