Viewing the current subsetting configuration
To display the Subsetting view, either:
- On the workspace management view, in the workspace navigation bar, click Subsetting.
- On Workspaces view, from the dropdown menu in the Name column, select Subsetting.
- On Workspaces view, click the subsetting icon for the workspace.
The Configuration tab on the Subsetting view shows the current subsetting configuration.
Configuration tab of the Subsetting view
It consists of:
- Subsetting summary
- Table View and Graph View. Both views display the source data tables and show the current subsetting configuration, and allow you to update the configuration. Table View displays a tabular list of tables. Graph View displays a diagram that shows the relationships between the tables.
- Configuration to enable subsetting for data generation
- Configuration for handling out-of-subset tables
- Results of the most recent subsetting data generation
The panels at the top of the Configuration tab provide a clickable summary of the current subsetting configuration.
Subsetting summary panels
The summary includes the following values:
- Target shows the number of target tables.
- Lookup shows the number of lookup tables.
- In Subset shows the number of tables that are in the subset. This includes target tables, lookup tables, and related tables.
- Out of Subset shows the number of tables that are not in the subset.
When you click a summary panel:
- On Table View, the table list is filtered to only display matching tables. For example, when you click Target, the list is filtered to only include target tables.
- On Graph View, the matching tables are highlighted with a shadow behind the table objects.
After you run data generation with subsetting, the Latest Results tab displays on the Configuration tab.
Results of the most recent data generation with subsetting
Before you run data generation with subsetting, the Latest Results tab does not display.
The Latest Results tab displays details for the most recent data generation with subsetting. It ignores data generation runs that do not use subsetting.
The subsetting results include:
- The job status (successful, failed, canceled).
- The amount of time it took to complete the run.
- The percentage of the source data that is included in the subset destination data.
- The volume of data in the source data and the subset destination data.
- The percent reduction from the original source data to the subset destination data.
- When the job began and ended.
To display the details for the data generation job, click View Job Details.
The Configuration tab contains the list of tables in the source database. It shows how each table is affected by the most recently completed subsetting configuration.
For each table, the table list includes:
- Whether the table is a target table, a lookup table, or a related table that is filtered.
- Whether the table is in or out of the subset. Target and lookup tables are always in the subset. Related tables also are in the subset. Other tables are out of the subset.
- The number of rows in the table before and after the subset is created. For tables that are in the subset, the percentage of table data that is in the subset. See How Tonic determines the number of pre-subset and post-subset rows.
- The number of direct inbound (downstream) and outbound (upstream) relationships for the table. An inbound relationship means that a primary key from another table is used as a value in the current table. An outbound relationship means that the primary key of the current table is a foreign key in another table. You can filter the upstream records to only include the records that you need. For target tables, the relationships are used to determine the related tables that are included in the subset. The related tables can also include other tables where the relationship is indirect.
You can sort the list based on values in a selected column. To use a column to sort the list, click the column heading. To switch the sort order, click the column heading again.
The Sort by dropdown list provides the following options to sort the list:
- Rows pre-subset - Sort by the number of rows in the table before subsetting.
- Rows post-subset - Sort by the number of rows in the table after subsetting. Before you run a data generation job to create the subset, this value is unknown.
- Inbound relationships - Sort the list based on the number of inbound relationships.
- Outbound relationships - Sort the list based on the number of outbound relationships.
- Total relationships - Sort the list based on the total number of inbound and outbound relationships.
By default, the drop-down sort options sort the table list in descending order. For example, when you select Rows pre-subset, the table that currently has the largest number of rows is at the top of the list. To change the sort direction, select the option again.
You can filter the list based on:
- The table name
- Whether the table is in or out of the subset
- Whether the table is a target or lookup table
To filter by table name, begin typing the name text into the filter field. As you type, the list is filtered to only include tables whose names contain the filter text.
To filter the list to show only target tables, lookup tables, in-subset tables, or out-of-subset tables, do one of the following:
- Click the panel at the top of the tab.
- From the Filter Tables drop-down list, select the filter option.
To remove a table subset status filter, click the delete icon.
You can combine a name filter and a table subset status filter. For example, you can filter the list to show in-subset tables that contain the text "test".
Multiple filters applied to the table list
You cannot combine the table subset status filters. When you select a different filter, the current filter is replaced.
Graph View displays a diagram of the source data tables and the relationships between them. It also indicates:
- Whether each table is in the subset.
- Whether the subsetting status for the table changed since the last subsetting data generation.
Graph View on the subsetting Configuration tab
Each table block provides the following information about the table:
- At the top left:
- The name of the table
- The name of the schema that contains the table
- At the top right, the status of the table in the context of the subset. A table might be a target table, a lookup table, a related table that is in the subset, or a table that is out of the subset.
- At the bottom, the number of rows in the table before and after the subset is created. See How Tonic determines the number of pre-subset and post-subset rows.
It also indicates the effect on the table of subset configuration changes that occurred since the most recent subsetting generation. See Identifying configuration changes since the most recent subsetting run.
The Graph View diagram connects tables that are related to each other based on a foreign key relationship. The position of the tables indicates the type of relationship.
- Tables that have an upstream relationship with another table are displayed above the table.
- Tables that have a downstream relationship with another table are displayed below the table.
- The Attendees table refers to the event for the attendee. Attendees is upstream of Events, and would display above the Events table in Graph View.
- The Events table refers to a venue from the Venues table. Venues is downstream of Events, and would display below the Events table in Graph View.
To find and focus on a specific table:
- 1.In the search field, begin to type text in the table name. As you type, Tonic filters the list to display matching tables.
- 2.When you see the table that you want, click the table name. Tonic centers the table on the graph, highlights the connections to other tables, and displays the table details panel.
To navigate around Graph View, you can click and drag to pan around the graph.
You can also use the navigation tools at the bottom left of Graph View to zoom in and zoom out.
For tables that contain fewer than 1,000 rows, the pre-subset number of rows is displayed as <1k.
For tables that are in the subset, the resulting rows are based on the target table and related table configuration.
For tables that are not in the subset, the resulting rows are based on whether you enable Process tables that are out of subset. See Determining how to process tables that are not in the subset.
If the data generation job hasn't run yet, or the details from the job are not yet available, then the number of rows after the subset is marked as unknown.
If you updated the configuration for a table since the most recent data generation, then on Table View, an information icon displays next to the post-subset value.
When you click a table in either Table View or Graph View, the table details panel displays to the right of the table.
The table details include:
- Whether the table is in the subset
- The number of rows before and after the subsetting. See How Tonic determines the number of pre-subset and post-subset rows.
- The number of inbound and outbound relationships
- The list of inbound and outbound relationships with other tables. When you click a table name, Tonic selects and displays the details for that table.
Table details