Database View

Database View provides a complete view of your source database structure and configuration.

It consists of:

  • On the left, the list of tables in the source database.

  • On the right, the list of columns in those tables.

To display Database View, either:

  • On the workspace management view, in the workspace navigation bar, click Database View.

  • On Workspaces view, from the dropdown menu in the Name column, select Database View.

From Database View, you can assign table modes to tables, assign generators to columns, and determine column sensitivity.

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.

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

    • S = Scale

    • 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.

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 by the assigned table mode

To filter the table list based on the assigned 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:

  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 that is assigned in the parent workspace, click Reset.

Updating multiple tables

To change the assigned table mode for 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.

Information in the column list

The column list contains the following columns:

Column

The Column column contains:

  • The name of the column, in the format table_name.column_name. When you click the column name, Table View for the column table displays.

  • The name of the schema that contains the table.

  • The data type for the column.

  • Access to view example source and destination values, based on the assigned generator. For more information, go to Displaying sample data for a column.

Applied Generator

Generator name tag

When a generator other than Passthrough is assigned, or when Passthrough is assigned to a non-sensitive column, the generator name tag displays the name of the assigned generator. To display the column configuration panel, click the generator name tag.

For sensitive columns that are assigned Passthrough:

  • If the Structural sensitivity scan marked the column as sensitive, then the generator name tag displays the type of sensitive information that Structural detected, such as a first name or a street address. The first time you click the generator name tag, you choose whether to assign or ignore the recommended generator. For more information, go to Assigning or ignoring the recommended generator.

  • If the column was marked manually as sensitive, then the generator name tag displays At-Risk. To display the column configuration panel, click the generator name tag.

The generator name tag is color-coded to indicate the sensitivity and protection status.

  • Protected columns use blue.

  • Unprotected sensitive columns use red.

  • Unprotected non-sensitive columns use gray.

If the table is assigned Truncate or Preserve Destination mode, then the generator name tag is hidden, unless you assigned a generator before you set the table mode.

Foreign key columns do not display a generator name tag.

Primary and foreign key tags

For primary key fields, the Applied Generator column contains a primary key tag.

For foreign keys, the foreign key tag replaces the generator name tag. Foreign key columns automatically inherit the value from the associated primary key column.

Assigned table mode

If the table is assigned a table mode other than De-Identify, then the Applied Generator column displays a table mode name tag.

Overrides in a child workspace

In a child workspace, when the assigned generator or generator configuration overrides the parent workspace, then an Override tag displays in the column.

If the table mode overrides the parent workspace, then the table mode tag displays the override icon. When the child workspace overrides the table mode, the Applied Generator column always displays the table mode, including the De-Identify table mode.

Comments

The Applied Generator column also provides access to view and add comments. For more information, go to Commenting on columns.

Filtering the column list

To filter the column list, you can:

  • Use the table list to filter the displayed columns based on the table that the columns belong to.

  • Use the filter field to filter the columns by table or column name.

  • Use the Filters panel to filter the columns based on column attributes and generator configuration.

You can use column filters to quickly find columns that you want to verify or update the configuration for.

Filter by table

To filter the column list to only include columns for specific tables, either:

Filter by table or column name

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

As you type, Structural filters the column list.

Using the Filters panel

The Filters panel provides access to column filters other than the table and column name.

To display the Filters panel, click Filters.

To search for a filter or a filter value, in the search field, start to type the value. The search looks for text in the individual settings.

For each filter, the Filters panel indicates the number of matching columns, based on the selected tables and the current filters.

Adding a filter

To add a filter, depending on the filter type, either check the checkbox or select a filter option. As you add filters, Structural applies them to the column list. Above the list, Structural displays tags for the selected filters.

Clearing the selected filters

To clear all of the currently selected filters, click Clear All.

Filters panel filters

Columns with generator recommendations

To only display detected sensitive columns for which there is a recommended generator, on the Filters panel, check Has Generator Recommendation.

At-risk columns

An at-risk column:

  • Is marked as sensitive

  • Is included in the destination data.

  • Is assigned the Passthrough generator.

To only display at-risk columns, on the Filters panel, check At-Risk Column.

When you check At-Risk Column, Structural adds the following filters under Privacy Settings:

  • Sets the sensitivity filter to Sensitive

  • Sets the protection status filter to Not protected

  • Sets the column inclusion filter to Included

Sensitivity

You can filter the columns based on the column sensitivity.

On the Filters panel, under Privacy Settings, the sensitivity filter is by default set to All, which indicates to display both sensitive and non-sensitive columns.

  • To only display sensitive columns, click Sensitive.

  • To only display non-sensitive columns, click Not sensitive.

Note that when you check At-risk Column, Tonic automatically selects Sensitive.

Protection status

You can filter the columns based on whether they have any generator other than Passthrough assigned. To filter the columns based on specific assigned generators, use the Applied Generator filter.

On the Filters panel, under Privacy Settings, the column protection filter is by default set to All, which indicates to display both protected and not protected columns.

  • To only display columns that have an assigned generator, click Protected.

  • To only display columns that do not have an assigned generator, click Not protected.

Note that when you check At-Risk Column, Structural automatically selects Not protected.

Inclusion in the destination database

You can filter the columns based on whether they are populated in the destination database. For example, if a table is truncated, then the columns in that table are not populated.

On the Filters panel, under Privacy Settings, the column inclusion filter is by default set to All, which indicates to display both included and not included columns.

  • To only display columns that are populated in the destination database, click Included.

  • To only display columns that are not populated in the destination database, click Not included.

Note that when you check At-Risk Column, Structural automatically selects Included.

Assigned generator

To only display columns that are assigned specific generators, on the Filters panel, under Applied Generator, check the checkbox for each generator to include.

The list of generators only includes generators that are assigned to the currently displayed columns and that are compatible with other applied filters.

To search for a specific generator, in the Filters search field, begin to type the generator name.

Column data type

You can filter the columns by the column data type. For example, you can only display varchar columns, or only columns that contain either numeric or integer values.

To only display columns that have specific data types, on the Filters panel, under Database Data Types, check the checkbox for each data type to include.

The list of data types only includes data types that are present in the currently displayed columns and that are compatible with other applied filters.

To search for a specific data type, in the Filters search field, begin to type the data type.

Unresolved schema changes

When the source database schema changes, you might need to update the configuration to reflect those changes. If you do not resolve the schema changes, then the data generation might fail. The data generation fails if there are unresolved conflicting changes, or if you configure Structural to always fail data generation when there are any unresolved changes.

For more information about schema changes, go to Viewing and resolving schema changes.

To only display columns that have unresolved schema changes, on the Filters panel, check Unresolved Schema Changes.

Sensitivity type

For detected sensitive columns, the sensitivity type indicates the type of data that was detected. Examples of sensitivity types include First Name, Address, and Email.

To only display columns that contain specific sensitivity types, on the Filters panel, under Sensitivity Type, check the checkbox for each sensitivity type to include.

The list of sensitivity types only includes sensitivity types that are present in the currently displayed columns.

To search for a specific sensitivity type, in the Filters search field, type the sensitivity type.

Column nullability

You can filter the column list based on whether the column is nullable.

On the Filters panel, under Data Attributes, the nullability filter is by default set to All, which indicates to display both nullable and non-nullable columns.

  • To only display columns that are nullable, click Nullable.

  • To only display columns that are not nullable, click Non-nullable.

Column uniqueness

You can filter the column list based on whether the column must be unique.

On the Filters panel, under Data Attributes, the uniqueness filter is by default set to All, which indicates to display both unique and not unique columns.

  • To only display columns that must be unique, click Unique.

  • To only display columns that do not require uniqueness, click Not unique.

Primary or foreign keys

You can filter the column list to indicate whether to include:

  • Columns that are not primary or foreign keys.

  • Columns that are foreign keys.

  • Columns that are primary keys.

On the Filters panel, under Column Type:

  • To display columns that are neither a primary key nor a foreign key, check Non-keyed.

  • To display columns that are primary keys, check Primary key.

  • To display columns that are foreign keys, check Foreign key.

Generator overrides in a child workspace

In a child workspace, to only display columns that override the generator configuration that is in the parent workspace, on the Filters panel, check Overrides Inheritance.

Uses Structural data encryption

You can enable Structural data encryption, a configuration that allows Structural to:

  • Decrypt source data before applying the generator

  • Encrypt generated data before writing it to the destination database

For more information, go to Configuring and using Tonic Structural data encryption.

When Structural data encryption is enabled, the generator configuration panel includes an option to use Structural data encryption.

To only display columns that are configured to use Structural data encryption, on the Filters panel, check Uses Data Encryption.

Sorting the column list

By default, the column list is sorted first by table name, then by column name. The columns for each table display together. Within each table, the columns are in alphabetical order.

You can also sort the column list by column name first, then by table. Columns that have the same name display together. Those columns are sorted by the name of the table.

The button at the right of the Column column heading indicates the current sort order.

  • T.C indicates that the table is sorted by table, then by column

  • C.T indicates that the table is sorted by column, then by table

To switch the sort order, click the button.

Configuring a single column

Displaying the column configuration panel

From the column list, to display the column configuration panel, click the generator name tag.

For a column that Structural detected as sensitive and that does not have an assigned generator (is assigned Passthrough), the generator name tag displays the type of sensitive data.

The first time that you click the generator name tag, Structural displays a panel that contains the following information:

  • The type of sensitive data that was detected

  • The recommended generator

  • Sample source and destination values based on the recommended generator

From the panel, you choose whether to assign or ignore the recommended generator for that type.

  • To assign the recommended generator, click Apply recommendation. Structural displays the column configuration panel with the recommended generator selected. You can then adjust the configuration or select a different generator.

  • To ignore the recommendation, click Ignore. Structural displays the column configuration panel to allow you to select the generator to assign to the column.

Indicating whether a column is sensitive

Required workspace permission: Configure column sensitivity

The Structural sensitivity scan provides an initial indication of whether a column is sensitive and, if it is sensitive, the type of sensitive data that is in the column. For more information, go to Identifying sensitive data.

From the column configuration panel, you can change whether a column is sensitive.

In a child workspace, you cannot configure whether a column is sensitive. A child workspace always inherits the sensitivity designation from its parent workspace.

On the column configuration panel, the sensitivity information is at the top right.

  • To indicate that a column is sensitive, toggle the Sensitivity setting to the on position.

  • To indicate that the column is not sensitive, toggle the Sensitivity setting to the off position.

Changing the column generator configuration

Required workspace permission: Configure column generators

To change the generator that is assigned to a selected column:

  1. Click the generator name tag for the column.

  2. On the column configuration panel, from the Generator Type dropdown list, select the generator.

  3. Configure the generator options.

To reset an assigned generator to Passthrough:

  1. Click the generator name tag.

  2. On the column configuration panel, click the delete icon next to the generator dropdown.

For details about the configuration options for each generator, go to the Generator reference.

For more information about selecting and configuring generators and generator presets, go to Assigning and configuring generators.

Configuring multiple columns

The bulk edit option allows you to configure multiple columns at the same time. From the bulk editing panel, you can:

  • Mark the selected columns as sensitive or not sensitive.

  • Assign a generator to the selected columns.

  • Apply the recommended generator to the selected columns.

  • Reset the generator configuration to the baseline. Requires that all of the selected columns are assigned the same preset.

Displaying the bulk edit option

To select the columns and display the bulk edit option:

  1. Check the checkbox next to each column to update.

  2. Click Bulk Edit.

Marking the columns as sensitive or not sensitive

Required workspace permission: Configure column sensitivity

On the Bulk Edit panel, under Edit Sensitivity:

  • To mark the selected columns as sensitive, click Sensitive.

  • To mark the selected columns as not sensitive, click Not Sensitive.

Changing the assigned generator

Required workspace permission: Configure column generators

On the Bulk Edit panel, under Bulk Edit Applied Generator, select and configure the generator to assign to the selected columns.

Assigning the recommended generator to the columns

Required workspace permission: Configure column generators

If any of the selected columns are unprotected sensitive columns that have a recommended generator, then on the Bulk Edit panel, to assign the recommended generators, click Apply Recommendations.

Restoring the baseline configuration for the columns

Required workspace permission: Configure column generators

For a generator preset, the baseline configuration is the configuration that is saved for that preset. The baseline configuration determines the default configuration is used when you assign the preset to a column. After you select the preset, you can override the baseline configuration.

If all of the selected columns are assigned the same preset, then to restore the baseline configuration for all of the columns, click Reset to Baseline.

Commenting on columns

Required license: Professional or Enterprise

You can add comments to columns. For example, you might use a comment to explain why you selected a particular generator or marked a column as sensitive or not sensitive.

If a column does not have any comments, then to add a comment:

  1. In the Applied Generator column, click the comment icon.

  2. In the comment field, type the comment text.

  3. Click Comment.

When a column has existing comments, the comment icon is green. To add comments:

  1. Click the comment icon. The comments panel shows the previous comments. Each comment includes the comment user.

  2. In the comment field, type the comment text.

  3. Click Reply.

Displaying sample data for a column

Required workspace permission:

  • Source data: Preview source data

  • Destination data: Preview destination data

For each column, you can display a sample list of the column values.

For columns that have an assigned generator, the sample shows both the current values and the possible values after the generator is applied.

To display the sample values, in the Column column, click the magnifying glass icon.

If the generator is Passthrough, then the sample data panel contains only Original Data.

If a different generator is assigned, then the sample data panel contains both Original Data and Protected Output.

Last updated