Skip to content
AskTable

Documentation feedback

Current pageField hiding and masking/en/data/hidden-fields

0 / 5,000

Your feedback will be sent to the maintenance team.

Go to console
Go to console

Configuration and administration

Field hiding and masking

Hide fields that are not needed for analysis and mask sensitive values in query results.

Guide · Module: data · Users · Deployment: Not specified · Confirmed product versions: Not specified · Source: Existing documentation

Field hiding excludes columns that are unnecessary for analysis. Field masking preserves a column's use in calculations while replacing sensitive values in results.

Intended effectWhat to useExample
The column is irrelevant and should not distract AIHide switchInternal auto-increment ID, creator ID
The column is needed for statistics, but its actual values should not be visibleMasking dropdownPhone number, national ID number, bank card number
The column is sensitive and not used for analysis at allBothAn archived national ID column never used in analysis

Before you start

ItemRequirement
PermissionsProject owner or administrator
PrerequisiteData source is available
Entry pointMain navigation on the left → “More” → “Data sources” → open a source card → select a table in the left tree

Steps

Hide a column

The rightmost column in “Field structure” is Hide, with a switch in each row. Turning it on grays out the entire row, indicating that the field no longer participates in AI analysis.

The explanation says AI ignores the column when answering after it is hidden. The switch takes effect immediately; there is no additional save button.

Restore a column

Turn off the Hide switch. The field's semantic vectors are retained, so it becomes searchable immediately when visible again without waiting for a rebuild.

Set a masking type

Click the field row to expand its detail panel and find the masking dropdown, whose explanation says values are masked according to the selected type. Choose one of six options:

Disabled, Person name, Phone number, National ID number, Bank card number, or Email.

Your selection saves immediately without confirmation. Choose Disabled to turn masking off.

Verify masking

After the change, ask a question that returns the column and check that values in the result table have been replaced. Masking occurs before query results reach the model, so the model sees replacement values.

Key constraints

ItemValue or defaultWhere to change it
Hiding scopeAI skips the column when generating queries, answering questions, and retrieving field semanticsHide switch in Field structure
Data deletion when hiddenNothing is deleted; the column and values remain in the table—
Restoring visibilityTurn the switch off; retained vectors make the field searchable immediatelySame switch
Masking typesDisabled, Person name, Phone number, National ID number, Bank card number, EmailMasking dropdown in the field detail panel
Where masking happensValues are replaced before query results are serialized for the model; original values do not enter the model—
Hiding versus maskingHiding excludes the entire column; masking keeps the column in use but replaces values—
Access-control boundaryThese switches affect only what AI sees; project roles and data access policies determine who can access which dataData access control

Troubleshooting

SymptomHow to identify itWhat to do
Switch has no effectInline message says field visibility could not be updatedRefresh and retry; contact an administrator if it persists
AI still mentions a fieldIts row is not gray and Hide is offTurn the switch on
Phone numbers remain unmaskedMasking dropdown is still DisabledChoose Phone number
Cannot change the masking typeInline message says masking type could not be updatedRefresh and retry; contact an administrator if it persists
A metric no longer works after hidingIt depends on the hidden columnHiding changes AI visibility, but the metric needs that field; use masking instead
Original values are needed but unavailableThe column has a masking type and conversation results contain replacementsMasking deliberately keeps original values from the model; query the database directly if you need them

Next steps