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

## Indicating whether a column is sensitive {% hint style="info" %} **Required workspace permission:** Configure column sensitivity {% endhint %} 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](/app/generation/identify-sensitive-data.md). 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. ## Assigning or ignoring the recommended generator {% hint style="info" %} **Required workspace permission:** Configure column generators {% endhint %} 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 {% hint style="info" %} **Required workspace permission:** Configure column generators {% endhint %} 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, click **Reset**, then click **Reset to Passthrough**. For details about the configuration options for each generator, go to the [Generator reference](/app/generation/generators/generator-reference.md). For more information about selecting and configuring generators and generator presets, go to [Assigning and configuring generators](/app/generation/generators-assign-config/generator-assignment-and-config.md). ## Enabling Document View for JSON columns {% hint style="info" %} Supported only for the file connector and PostgreSQL. {% endhint %} 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 [Using Document View for JSON columns](/app/generation/working-with-document-based-data/json-document-view.md). 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](/app/generation/generators-assign-config/custom-value-processors.md), or enabled [Structural data encryption](/app/generation/generators-assign-config/generators-data-encryption-config.md), 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. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.tonic.ai/app/generation/database-view/database-view-configure-column.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.