Configuring an individual column
Last updated
Was this helpful?
Last updated
Was this helpful?
For an individual column in Database View, you can configure the assigned generator and determine the column sensitivity.
From the column list, to display the generator configuration panel, in the Applied Generator column, click the generator name tag.
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.
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.
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.
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.
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.
When a column matches a sensitivity rule, the sensitivity panel indicates that the column matched a sensitivity rule.
You use the Sensitive data? toggle to indicate whether the column is actually sensitive.
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.
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.
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.
To configure the sensitivity, you can also use the Sensitive Data 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.
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.
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.
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.
To change the generator that is assigned to a selected column:
Click the generator name tag for the column.
To assign a different generator to the column, from the Generator Type dropdown list, select the generator.
Configure the generator options.
To reset an assigned generator to Passthrough, which indicates to not transform the data:
Click the generator name tag.
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.
For a file connector 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 file connector JSON columns.
When Document View is enabled, the generator dropdown is replaced with the Open in Document View option.
To enable Document View, on the column configuration panel, toggle Use Document View to the on position. Note that if you have , or enabled , then the Use Document View toggle is in the advanced options.
