Viewing the column list
The column list on Database View contains information about the sensitivity and generator configuration for each column.
Column - Column name and type
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 - Column configuration
The Applied Generator column provides information about the column sensitivity and generator configuration. It also provides access to create and respond to column comments.
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:
Check the checkbox for each table to display columns for.
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.
Searching for a filter
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 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.
Last updated