# Data Profiling

In order to run profiling analysis first we need to have setup some [data source](https://docs.truedat.io/administration/sources#id-2.6Managingconnectorsandsources-Source) with this option enabled. Usually this type of analysis is allowed in data sources in which we may run SQL since the processing of the profiling is delegated to the source data base engine.

The option to run profiling will be assigned depending on the [role and permissions](https://docs.truedat.io/administration/userroles#data-dictionary-data-catalog) that you have for the given data structure.

## Executing Profiling Analysis

Once you have structures which source allows to run profiling and you have the permissions to do it you just need to navigate to the structure for which you want to execute the profiling analysis:

![Find the execute profile option on the right upper corner](https://content.gitbook.com/content/tPZLjBmastIn9sM2Qlbc/blobs/yjCbq59gi0oujnDNKGRH/2021-05-21%2011_57_59-Truedat.png)

You will have to select for which fields you want to run your analysis. This will be executed in your data source, aim for efficiency analysing only the information you need.

![You will need to manully refresh your screen](https://content.gitbook.com/content/tPZLjBmastIn9sM2Qlbc/blobs/3M0sAHrDiqqB6ptw2psl/2021-05-21%2012_01_07-20210521%20Planificacion%20Conectores.xlsx%20-%20Excel.png)

![until results are produced](https://content.gitbook.com/content/tPZLjBmastIn9sM2Qlbc/blobs/2uop6pM0VvvnEFMiyXDH/2021-05-21%2012_03_04-20210521%20Planificacion%20Conectores.xlsx%20-%20Excel.png)

## Profiling Analysis

Once you have run profiling information this will be availble for all users with permissions to see profiling. This information will be displayed through the Data Catalog at a data structure level

![Profiling view within table](https://content.gitbook.com/content/tPZLjBmastIn9sM2Qlbc/blobs/qzKyspQt6qJQGoOQkgHv/2021-05-21%2014_04_03-Truedat.png)

![Field's value distribution](https://content.gitbook.com/content/tPZLjBmastIn9sM2Qlbc/blobs/VsJAcbE5oVx1BIj7b4rT/2021-05-21%2014_04_33-20210521%20Planificacion%20Conectores.xlsx%20-%20Excel.png)


---

# 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.truedat.io/userguide/data-profiling.md?ask=<question>
```

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.