Viewing and configuring tables

The table list at the left of Database View contains the list of tables in the source database. You can filter the table list and assign tables modes to the tables.

You can use the Structural Agent to filter Database View to a specific table. For example:

• Display the products table on Database View.
• Show me the stores and vendors tables on Database View.

Information in the table list

The table list is grouped by schema. You can expand and collapse the list of tables in each schema. This does not affect the displayed columns.

For a file connector workspace, each table corresponds to a file group.

Table list on Database View

For each table, the table list includes the following information:

• The name of the table.
• The number of columns that have an assigned generator (a generator other than Passthrough). The number does not display if none of the table columns has an assigned generator.
• The assigned table mode. The table list only shows the first letter of the table mode:

  • D = De-identify
  • T = Truncate
  • P = Preserve Destination
  • I = Incremental

For a child workspace, if the selected table mode overrides the parent workspace configuration, then the override icon displays.

Table that overrides the configuration from the parent workspace

To display Table View for a table, click the arrow icon to the right of the table entry.

Filtering the table list

You can filter the table list by name and by the assigned table mode. You can also filter the tables based on whether any of the columns have assigned generators.

As you filter the table list, the column list also is filtered to only include the columns for the filtered tables.

Filtering by table name

To filter the table list by name, in the filter field, begin to type text that is in the table name.

As you type, Tonic Structural filters the list to only display tables with names that contain the filter text.

Filtering the table list by table name

Filtering by the assigned table mode

To filter the table list based on the assigned table mode:

Filtering the table list by table mode

1. Click Filters.
2. On the filter panel, check the checkbox next to each table mode to include. By default, the list includes all of the table modes. As you check and uncheck the table mode checkboxes, Structural adds and removes the associated tables from the list.

Filtering to exclude tables that have assigned generators

You can filter the table list to only display tables that have no assigned generators:

1. Click Filters.
2. On the filter panel, to only show tables that do not have assigned generators, check the No Generators Applied checkbox.

Assigning table modes to tables

Required workspace permission: Assign table modes

The table mode determines the number of rows and columns in the destination database. For details about the available table modes and how they work, go to Table modes.

Updating a single table

To change the assigned table mode for a single table:

Assigning a table mode to a single table

1. Click the table mode dropdown next to the table name.
2. From the table mode dropdown list, select the table mode.
3. For a child workspace, the table mode selection panel indicates whether the selected table mode is inherited from the parent workspace. If the child workspace currently overrides the parent workspace configuration, then to reset the table mode to the table mode that is assigned in the parent workspace, click Reset.

Updating multiple tables

To change the assigned table mode for multiple tables:

Assigning a table mode to multiple tables

1. Check the checkbox for each table to change the table mode for. To select a continuous range of tables, click the first table in the range, then Shift-click the last table in the range. To select all of the tables in a schema, click the schema name.
2. Click Bulk Edit.
3. On the panel, click the radio button for the table mode to assign to the selected tables.