Data profiling of a column

In the Data Profiling tab of a Column asset, you can see the details of the column.

The details are grouped in some fixed sections:

Section Content
Metadata

Contains the metadata of the column, such as data type, column name and so on.

Counts

Contains basic content information, such as number of rows and number of distinct values.

Basic Statistics

Contains the basic statistics of the data, such as minimum and maximum value.

Depending on the column's data type, you can find extra sections:

Section Content
Quantiles

Contains the descriptive statistics of the data.

This section is only available if the data type is numerical.

Categorical Data

Contains the values of the different categories.

If there are too many values, only the first 50 and last 50 values are displayed.

Chart

Displays the statistics in a graphical way. The chart type varies per data type:

  • bar chart: textual data
  • data distribution: numerical data and date and time data

See also Data profiling charts.

Note If you use the Jobserver to register a data source and you have enabled the Anonymize data option in Collibra Console,Collibra anonymizes data in Column assets that have data type Text and Geo. If you use Edge to register a data source, your data is automatically anonymized.