Configuring an individual column

For an individual column in Database View, you can configure the assigned generator and determine the column sensitivity.

Displaying the generator configuration panel

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

Generator configuration panel

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.

  • The confidence level of the sensitivity detection.

For more information, go to Identifying sensitive data.

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

Status column

From the Status column, to confirm or change the column sensitivity, click the Status value.

The status panel indicates whether the column is sensitive. It identifies the sensitivity type, and indicates how the sensitivity was determined - by a sensitivity scan or by a user.

Built-in sensitivity type

For a column that matches a built-in sensitivity type, the first time that you display the panel, the Sensitive data? setting displays Yes and No options for you to confirm or change the sensitivity.

Column status panel with confirmation options
  • To indicate that the column is sensitive, click Yes.

  • To indicate that the column is not sensitive, click No.

When you click Yes or No, the Yes and No options change to a simple toggle. When you click Yes, the sensitivity confidence level changes to full.

Status panel after you select No or Yes to indicate the sensitivity

After that:

  • To indicate that the column is sensitive, toggle Sensitive data? to the on position.

  • To indicate that the column is not sensitive, toggle Sensitive data? to the off position.

Sensitivity rule match

When a column matches a sensitivity rule, the sensitivity panel indicates that the column matched a sensitivity rule.

Sensitivity panel for a column that matched a sensitivity rule

You use the Sensitive data? toggle to indicate whether the column is actually sensitive.

No built-in sensitivity type or sensitivity rule match

When a column does not match a built-in sensitivity type or a custom sensitivity rule, the sensitivity panel indicates that column is not sensitive.

Sensitivity panel for a not sensitive column

The Sensitive data? setting displays Yes and No options for you to confirm or change the sensitivity.

  • To indicate that the column is sensitive, click Yes.

  • To confirm that the column is not sensitive, click No.

When you click Yes or No, the Yes and No options change to a simple toggle.

If you click Yes:

  • The panel updates to indicate that a user confirmed that the column is sensitive.

  • The sensitivity confidence level is set to full confidence.

Sensitivity panel after you change the sensitivity on a not sensitive column

After that:

  • To indicate that the column is sensitive, toggle Sensitive data? to the on position.

  • To indicate that the column is not sensitive, toggle Sensitive data? to the off position.

Column configuration panel

To configure the sensitivity, you can also use the Sensitive Data toggle on the column configuration panel.

Sensitivity toggle on the column configuration panel
  • 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.

When you change the sensitivity from the generator configuration panel, the Sensitive data? setting on the sensitivity panel also changes from the Yes and No options to the toggle.

Required workspace permission: Configure column generators

When a sensitivity scan identifies a column, Structural recommends a generator for the column. For example, when the sensitivity scan identifies a column as a first name, Structural recommends the Name generator configured to generate a first name value.

In the Assigned Generator column on Database View, columns that do not have an assigned generator, and that have a recommended generator, display the available recommendation icon.

Column with the available recommendation icon

When you click the generator dropdown, the column configuration panel includes the following information:

  • The sensitivity confidence level.

  • The recommended generator.

  • Sample source and destination values based on the recommended generator.

Recommended generator panel for a column

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

  • To assign the recommended generator, click Apply.

  • To ignore the recommendation, click Ignore. Structural clears the recommendation.

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. To assign a different generator to the column, from the Generator Type dropdown list, select the generator.

  3. Configure the generator options.

To reset an assigned generator to Passthrough, which indicates to not transform the data:

  1. Click the generator name tag.

  2. On the generator 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.

Enabling Document View for JSON columns

Supported only for the file connector and PostgreSQL.

For a JSON column, instead of assigning a generator, you can enable Document View.

From Document View, you can view the JSON schema structure and assign generators to individual JSON fields. For more information, go to Document View for JSON columns.

To enable Document View, on the column configuration panel, toggle Use Document View to the on position. Note that if you have custom value processors, or enabled Structural data encryption, then the Use Document View toggle is in the advanced options.

When Document View is enabled, the generator dropdown is replaced with the Open in Document View option.

Last updated

Was this helpful?