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.
Database View
Child workspaces inherit all table and column configuration from their parent workspace. For child workspaces, Database View is read-only. See About workspace inheritance.

Managing tables

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.
Table list
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
To display Table View for a table, click the table icon for the table.

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 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. 1.
    Click Filter.
  2. 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, Tonic 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. 1.
    Click Filter.
  2. 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

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, see Table modes.
To change the assigned table mode for a single table:
Assigning a table mode to a single table
  1. 1.
    Click the table mode dropdown next to the table name.
  2. 2.
    From the Table Mode dropdown list, select the table mode.
To change the assigned table mode for multiple tables:
Assigning a table mode to multiple tables
  1. 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. 2.
    Click Bulk Edit.
  3. 3.
    On the panel, click the radio button for the table mode to assign to the selected tables.

Managing columns

Information in the column list

For each column, the column list includes the following information:
Column list
  • The name of the column, in the format tableName.columnName. When you click the column name, Table View for the column table displays.
  • The data type of the column.
  • For columns that are not foreign keys, the generator that is assigned to the column. For columns that are assigned Passthrough, if the column is marked as sensitive, then the generator dropdown is red.
  • For columns that are foreign keys, a label to indicate that the column is a foreign key. You do not assign a generator to a foreign key. It automatically uses the generator that is assigned to the primary key that provides the foreign key value. See Primary key generators.
  • If there is a comment on the column, the comment icon.
  • The selected configuration options for the assigned generator.

Filtering the column list

The column list is automatically filtered when you filter the table list. You can also filter the column list to only display columns for specific selected tables.
From the column list, you can filter the columns by column name. Tonic also provides advanced options to filter the columns by:
The advanced filters also include a filter to only display columns that have unresolved schema changes. This filter does not combine with the other column filters.
Column filtering options
You can use column filters to quickly find columns that you want to verify or update the configuration for.

Filtering by table

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

Filtering by column name

To filter the column list by column name, in the filter field, begin typing text that is in the column name. The filter only looks for the text in the column name, not the table name.
As you type, Tonic filters the column list.
Filtering columns by name

Filtering by column data type

You can filter the columns by their data type. For example, you can only display varchar columns, or only columns that contain either numeric or integer values.
To filter the column list by data type:
  1. 1.
    Click Filter.
  2. 2.
    On the filter panel, in the Data Type field, enter the data types to include in the column list.
  3. 3.
    As you type, Tonic displays a list of matching types to select from.
As you select each type, Tonic adds it to the main filter field and updates the column list.
Filtering columns by data type

Filtering by the assigned generator

You can filter the list based on the assigned generator. For example, you can only display columns that are assigned either the Name or Address generators.
To filter the column list by the assigned generator:
  1. 1.
    Click Filter.
  2. 2.
    On the filter panel, in the Applied Generator field, enter the generators to include in the column list.
  3. 3.
    As you type, Tonic displays a list of matching generators to select from.
As you select each generator, Tonic adds it to the main filter field and updates the column list.
Filtering columns by assigned generator

Filtering for at-risk columns

In the advanced filter options, the At-Risk toggle provides a shortcut to set the Sensitivity, Protection, and Destination Data filters. It allows you to quickly identify sensitive columns that are populated in the destination database but do not have an assigned generator.
To enable the At-Risk filter:
  1. 1.
    Click Filter.
  2. 2.
    On the filter panel, next to the Privacy Settings heading, toggle At-Risk to the on position.
When you toggle At-Risk to the on position:
  • Sensitivity is set to Sensitive.
  • Protection is set to Not Protected.
  • Destination Data is set to Included.
Filtering for at-risk columns
If you change any of these filters, the At-Risk toggle returns to the off position.

Filtering by column sensitivity

You can filter the list to only show sensitive or not sensitive columns. For example, you can use this filter to verify that all of the sensitive columns have assigned generators, or that all of the columns that contain sensitive data are correctly marked as sensitive.
To filter the column list based on whether the column is marked as sensitive:
  1. 1.
    Click Filter. By default, the list includes both sensitive and non-sensitive columns. Under Privacy Settings, the sensitivity filter is set to All.
  2. 2.
    To only include columns that are marked as sensitive, click Sensitive.
  3. 3.
    To only include columns that are marked as non-sensitive, click Not Sensitive.
When you select Sensitive or Not Sensitive, Tonic adds it to the main filter field and updates the column list.
Filtering columns by sensitivity

Filtering by whether the column is protected

You can filter the list to find columns that either are or are not protected. A column is protected if it as an assigned generator other than Passthrough. For example, you can use this filter to find sensitive columns that need a generator assignment.
To filter the column list based on whether the column has an assigned generator other than Passthrough:
  1. 1.
    Click Filter. By default, the list includes all columns. Under Privacy Settings, the protection filter is set to All.
  2. 2.
    To only include columns that have an assigned generator, click Protected.
  3. 3.
    To only include columns that do not have an assigned generator, click Not Protected.
When you select Protected or Not Protected, Tonic adds it to the main filter field and updates the column list.
Filtering by protection status

Filtering by whether the column is populated 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 in the destination database, then the columns in that table are not populated.
To filter the columns based on whether they are populated in the destination database:
  1. 1.
    Click Filter. By default, the list contains both included and excluded columns. Under Privacy Settings, the Destination Data filter is set to All.
  2. 2.
    To only include columns that are populated in the destination database, click Included.
  3. 3.
    To only include columns that are not populated in the destination database, click Not Included.
When you select Included or Not Included, Tonic adds it to the main filter field and updates the column list.
Filtering based on whether the column is included in the destination database

Filtering by column nullability

To filter the column list based on whether the column is nullable:
  1. 1.
    Click Filter. By default, the list includes all columns. Under Data Attributes, the nullability filter is set to All.
  2. 2.
    To only include columns that are nullable, click Nullable.
  3. 3.
    To only include columns that are not nullable, click Not Nullable.
When you select Nullable or Not Nullable, Tonic adds it to the main filter field and updates the column list.
Filtering columns by whether they are nullable

Filtering by column uniqueness

To filter the column list based on whether the column values are required to be unique:
  1. 1.
    Click Filter. By default, the list includes all columns. Under Data Attributes, the uniqueness filter is set to All.
  2. 2.
    To only include columns that are unique, click Unique.
  3. 3.
    To only include columns that are not unique, click Not Unique.
When you select Unique or Not Unique, Tonic adds it to the main filter field and updates the column list.
Filtering columns by whether they are unique

Filtering by whether a column is a primary or foreign key

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.
To indicate which columns to include:
  1. 1.
    Click Filter.
  2. 2.
    The Column Type toggles control whether to include each type of column. By default, all of the toggles are in the on position, indicating to include all types of columns.
  3. 3.
    As you turn the toggles on or off, Tonic filters the column list.
Filtering columns based on whether the column is a primary or foreign key

Filtering for 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 Tonic to always fail data generation when there are any unresolved changes.
For more information about schema changes, see Viewing and resolving schema changes.
To only display columns that have unresolved schema changes, on the advanced settings panel, under Only Show, check the Unresolved Schema Changes checkbox.
Filter for columns that have unresolved schema changes
You cannot combine this filter with the other column filters. When you check Unresolved Schema Changes, the other filters are disabled, but Tonic remembers the current settings. When you uncheck Unsolved Schema Changes, Tonic automatically restores and applies the other filters.

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.
To change the column sort order:
  1. 1.
    Click Sort columns.
  2. 2.
    On the sort panel, click the dropdown.
  3. 3.
    In the list of sort options, click the option to apply to the list.

Updating the column configuration

From the column list, you can change the generator assignments and indicate whether columns are sensitive.

Assigning generators to columns

To change the generator that is assigned to a selected column:
Selecting and configuring a generator for a column
  1. 1.
    Click the generator value for the column.
  2. 2.
    On the configuration panel, from the Generator Type dropdown list, select the generator.
  3. 3.
    Configure the generator options.
To assign a generator to multiple columns:
Assigning a generator to multiple selected columns
  1. 1.
    Check the checkbox next to each column to configure. To select a continuous range of columns, check the checkbox of the first column in the range, then Shift-click the last column in the range.
  2. 2.
    Click Bulk Edit Generator.
  3. 3.
    From the New Generator dropdown list, select the generator to assign to the selected columns.
  4. 4.
    Configure the generator options.
To reset an assigned generator to Passthrough, click the delete icon next to the generator dropdown.
For details about the configuration options for each generator, see the Generator reference.

Indicating whether columns are sensitive

When you create a workspace, Tonic performs an initial sensitivity scan to identify columns that contain sensitive data.
If a column is sensitive, and is assigned Passthrough as the generator, then the generator dropdown is red. If a column is assigned a generator other than Passthrough, then the generator dropdown is not red.
From the column list, you can change whether a column is sensitive.
To change the sensitivity for an individual column:
Sensitivity toggle for an individual column
  1. 1.
    Click the generator for the column. The Sensitivity setting is at the top right of the configuration panel.
  2. 2.
    To indicate that a column is sensitive, toggle the setting to the on position.
  3. 3.
    To indicate that the column is not sensitive, toggle the setting to the off position.
To change the sensitivity for multiple columns:
Configuring sensitivity for multiple selected columns
  1. 1.
    Check the checkbox next to each column to configure. To select a continuous range of columns, check the checkbox of the first column in the range, then Shift-click the last column in the range.
  2. 2.
    Click Bulk Edit Sensitivity. The sensitivity panel shows the number of selected columns that are sensitive and not sensitive. If all of the columns have the same sensitivity, then that radio button is selected.
  3. 3.
    To make all of the selected columns sensitive, click the Sensitive radio button.
  4. 4.
    To make all of the selected columns not sensitive, click the Not Sensitive radio button.

Commenting on columns

The commenting feature requires an Enterprise tier license.
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:
Comment panel for a column that has no comments
  1. 1.
    Hover over the column row. The comment icon displays after the generator dropdown.
  2. 2.
    Click the comment icon.
  3. 3.
    In the comment field, type the comment text.
  4. 4.
    Click Comment.
When a column has existing comments, a green comment icon displays at the end of the column row. To add comments:
Replying to existing comments on a column
  1. 1.
    Click the comment icon. The comments panel shows the previous comments. Each comment includes the comment user and timestamp.
  2. 2.
    In the comment field, type the comment text.
  3. 3.
    Click Reply.

Displaying sample data for a column

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, click the magnifying glass icon for the column.
If the generator is Passthrough, then the sample data panel contains only Original Data.
Sample data for a column that does not have an assigned generator
If a different generator is assigned, then the sample data panel contains both Original Data and Protected Output.
Sample data for a column that has an assigned generator
Copy link
On this page
Managing tables
Information in the table list
Filtering the table list
Assigning table modes to tables
Managing columns
Information in the column list
Filtering the column list
Sorting the column list
Updating the column configuration
Commenting on columns
Displaying sample data for a column