> ## Documentation Index
> Fetch the complete documentation index at: https://docs.wisdom.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Advanced Column Options

If you toggle the **Show advanced options** switch on, the following additional configuration fields will appear, allowing for more granular control over your data model:

| **Field**                | **Description**                                                                                                                                                    |
| :----------------------- | :----------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Primary Key**          | Identifies if the column is a unique identifier for the rows in the table.                                                                                         |
| **Default Order**        | Sets the default sorting direction (Ascending or Descending) for the column.                                                                                       |
| **Allowed values**       | Defines a list of valid entries to guide WisdomAI's understanding of the column's content. These values are case-sensitive and are used for semantic context only. |
| **Order allowed values** | Enables or disables a specific custom sorting order for the defined allowed values. This custom sequence overrides the Default Order setting.                      |
| **User identifier**      | Marks the column as containing user-specific identifying information such as email or username.                                                                    |
| **Enable Lookups**       | Toggles whether this column can be used for data lookup operations and Name-Entity Recognition (NER).                                                              |

## Understanding lookups and NER

Enabling lookups on textual columns powers Name-Entity Recognition (NER). This helps Wisdom build more accurate SQL queries by mapping user intent to specific database values. The key benefits of enabling this feature are:

* **Token matching**: WisdomAI identifies the right column to query based on tokens in the question string. For example, "Show me total usage for compute services" will match `service_category = compute`, whereas "total usage for EC2 services" will match `service_name = compute`.
* **Typo correction**: Fixes minor typos in user questions. For example, "Show me total usage for computer services" will be auto-corrected to `service_category = compute`.

<Tip>
  Enable lookups on **VARCHAR** type columns that contain categorical dimensions, such as region names, customer names, or category types.
</Tip>

<img src="https://mintcdn.com/wisdomai/1Caj4qE896t0xRx7/images/advanced-config-columns.png?fit=max&auto=format&n=1Caj4qE896t0xRx7&q=85&s=104f0044f690d7135485f0a977ad7ecf" alt="A table view of database columns showing advanced configuration options, such as Primary Key and Allowed Values, enabled by the &#x22;Show advanced options&#x22; toggle." lightAlt="A table view of database columns showing advanced configuration options, such as Primary Key and Allowed Values, enabled by the &#x22;Show advanced options&#x22; toggle." darkAlt="A table view of database columns showing advanced configuration options, such as Primary Key and Allowed Values, enabled by the &#x22;Show advanced options&#x22; toggle." className="dark:hidden" width="1803" height="521" data-path="images/advanced-config-columns.png" />

<img src="https://mintcdn.com/wisdomai/FPeFp9c8fz1r_sxU/dark-img/advanced-config-columns.png?fit=max&auto=format&n=FPeFp9c8fz1r_sxU&q=85&s=bb57933360cd07115c313b3dee8b3894" alt="A table view of database columns showing advanced configuration options, such as Primary Key and Allowed Values, enabled by the &#x22;Show advanced options&#x22; toggle." lightAlt="A table view of database columns showing advanced configuration options, such as Primary Key and Allowed Values, enabled by the &#x22;Show advanced options&#x22; toggle." darkAlt="A table view of database columns showing advanced configuration options, such as Primary Key and Allowed Values, enabled by the &#x22;Show advanced options&#x22; toggle." className="hidden dark:block" width="1803" height="521" data-path="dark-img/advanced-config-columns.png" />

<CardGroup cols={3}>
  <Card title="Advanced Data Modeling" icon="sitemap" href="/setting-up-wisdom-ai/advanced-data-modeling-creating-context">
    Define relationships and context in your data to enable more powerful analysis.
  </Card>

  <Card title="Provide Feedback to the System" icon="thumbs-up" href="/setting-up-wisdom-ai/feedback-mechanisms/provide-feedback-to-the-system">
    Learn how to rate answers and provide corrections to improve the system's accuracy.
  </Card>

  <Card title="Understand Domains" icon="sliders" href="/setting-up-wisdom-ai/manage-domains/understand-domains">
    Manage and customize your data domains to refine context and improve query results.
  </Card>
</CardGroup>