> For the complete documentation index, see [llms.txt](https://docs.sprinkledata.com/product/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.sprinkledata.com/product/analysing-your-data/data-models/column-mask.md).

# Column Mask

#### What is Data Masking?

It can be described as a method of modifying confidential data so that the actual values cannot be accessed. The data masking technique used in this feature is Dynamic Data Masking. It means temporarily hiding the data from users when they access it.

#### Why is it required? 

To Mask sensitive information like PII, PHI, and other confidential data from specific groups of users who do not require it on the platform.

#### Steps involved in creating column masks

1. On a Model, browse to the Column Mask Section. 
2. :mouse\_three\_button:Click on the “**+ Add Mask**” Button, to create a new mask. 
3. The Masks you create are mapped to a group of users, who must be restricted from accessing the columns. So from the group name dropdown, select the group for which the mask is to be created.
4. Then from a list of columns in the model, select those that have to be masked.
5. By clicking the tick button, you can create the mask for the columns in the selected group.

#### So, what happens when a mask is created?

The masks are honoured when [Reports](broken://pages/Hzy6JZnG8PkHQD4M39M9) are generated from the model with masked columns. If users from the masked group access the report, they will see asterisks rather than actual data in those masked columns, while other columns normally show data. 

Also when such [Reports](broken://pages/Hzy6JZnG8PkHQD4M39M9) are embedded onto a dashboard the masks are honoured.

{% hint style="success" %}
**Good to Know** 

* In [Reports](broken://pages/Hzy6JZnG8PkHQD4M39M9), the masked columns are not available for filtering and sorting data. 
* When a restricted group of users downloads the report, the column masks are respected in the downloaded file. 
* Even when models are joined, the column masks remain intact.
  {% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.sprinkledata.com/product/analysing-your-data/data-models/column-mask.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.