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

# Profiler Tab | Data Profiling Interface

> Use the profiler tab to configure, view, and manage profiling metrics including null counts, uniqueness, and stats.

# Profiler Tab

The Data Observability tab is displayed only for Tables. It has three sub-tabs for **Table Profile, Column Profile, and Data Quality**.

## Table Profile Tab

The **Table Profile** tab displays structural metrics and timeseries charts for a table, giving a clear picture of how data volume and composition change over time.

<img src="https://mintcdn.com/collatedocs/kIcf12aq0fGgWkOd/public/images/ai-2.0/data-observability/data-profiler/table-profile-tab.png?fit=max&auto=format&n=kIcf12aq0fGgWkOd&q=85&s=6df7cc80f9b0feb5880af0385b209f0d" alt="Table Profile" width="2714" height="1390" data-path="public/images/ai-2.0/data-observability/data-profiler/table-profile-tab.png" />

The tab shows the following:

* **Row Count**: The total number of rows in the table, tracked over the selected date range.

* **Column Count**: The total number of columns in the table.

* **Profile Sample Type**: The portion of data profiled, shown as a percentage or an absolute row count.

* **Size**: The total size of the table on disk.

* **Created Date**: The date the table was first created.

* **Data Volume**: A timeseries chart showing how row count evolves over the selected time period.

  <img src="https://mintcdn.com/collatedocs/MrJbbiNG3Gqux6Hk/public/images/how-to-guides/quality/dv.png?fit=max&auto=format&n=MrJbbiNG3Gqux6Hk&q=85&s=ee97df728674d0c297ee367df0276aa9" alt="Table Profile: Data Volume" width="2943" height="717" data-path="public/images/how-to-guides/quality/dv.png" />

* **Table Updates**: A timeseries chart showing the number of inserts, updates, and deletes that occurred in the table over time.

  <img src="https://mintcdn.com/collatedocs/MrJbbiNG3Gqux6Hk/public/images/how-to-guides/quality/tu.png?fit=max&auto=format&n=MrJbbiNG3Gqux6Hk&q=85&s=5cdcdae593903de972f0263ffce0c0be" alt="Table Profile: Table Updates" width="2943" height="717" data-path="public/images/how-to-guides/quality/tu.png" />

* **Volume Change**: A timeseries chart showing the volume of data affected by inserts, updates, and deletes over the selected period.

  <img src="https://mintcdn.com/collatedocs/MrJbbiNG3Gqux6Hk/public/images/how-to-guides/quality/vc.png?fit=max&auto=format&n=MrJbbiNG3Gqux6Hk&q=85&s=3ea8513aa9ca5fde338cae8f323b8725" alt="Table Profile: Volume Change" width="2018" height="706" data-path="public/images/how-to-guides/quality/vc.png" />

## Column Profile Tab

The **Column Profile** tab shows profiling metrics for every column in a table, making it easy to spot data quality issues at the column level.

<img src="https://mintcdn.com/collatedocs/kIcf12aq0fGgWkOd/public/images/ai-2.0/data-observability/data-profiler/coulmn-profiler-tab.png?fit=max&auto=format&n=kIcf12aq0fGgWkOd&q=85&s=4e5112679cb83be2d4c4308e9a295b15" alt="Column Profile of a Table" width="2764" height="1550" data-path="public/images/ai-2.0/data-observability/data-profiler/coulmn-profiler-tab.png" />

The tab lists all columns with the following metrics:

* **Name**: The unique identifier for the column within the table.
* **Data Type**: The kind of data stored in the column, such as integer, string, boolean, or timestamp.
* **Null %**: The share of rows where this column has no value.
* **Unique %**: The share of values that appear exactly once in the column.
* **Distinct %**: The share of values that are different from each other, regardless of how often they repeat.
* **Value Count**: The number of rows that contain a non-null value in this column.
* **Success / Failed / Aborted**: Results of the most recent data quality test run on this column.

Select any column to open its detailed profile.

<img src="https://mintcdn.com/collatedocs/kIcf12aq0fGgWkOd/public/images/ai-2.0/data-observability/data-profiler/column-profile.png?fit=max&auto=format&n=kIcf12aq0fGgWkOd&q=85&s=f0c7184ba5b7c7ae45e25c7f70ea4c19" alt="Column Profile of a Column" width="2768" height="1374" data-path="public/images/ai-2.0/data-observability/data-profiler/column-profile.png" />

The detail view shows the column's description, glossary terms, and tags alongside a **Data Quality Tests** summary. It also displays the following timeseries charts:

* **Data Counts**: A chart showing the number of Distinct, Null, Unique, and total Values in the column over time.

  <img src="https://mintcdn.com/collatedocs/MrJbbiNG3Gqux6Hk/public/images/how-to-guides/quality/dc.png?fit=max&auto=format&n=MrJbbiNG3Gqux6Hk&q=85&s=768ab3df6780a51c46a5949f4a6b96e4" alt="Column Profile: Data Counts" width="2024" height="714" data-path="public/images/how-to-guides/quality/dc.png" />

* **Data Proportions**: A chart showing the Distinct %, Null %, and Unique % ratios in the column over time.

  <img src="https://mintcdn.com/collatedocs/MrJbbiNG3Gqux6Hk/public/images/how-to-guides/quality/dp.png?fit=max&auto=format&n=MrJbbiNG3Gqux6Hk&q=85&s=464f4f163f673c354ce11b06de2abc1b" alt="Column Profile: Data Proportions" width="2943" height="717" data-path="public/images/how-to-guides/quality/dp.png" />

* **Data Range**: A chart showing the Minimum, Maximum, and Mean character lengths for string columns — useful for text and NLP analysis.

  <img src="https://mintcdn.com/collatedocs/MrJbbiNG3Gqux6Hk/public/images/how-to-guides/quality/dr.png?fit=max&auto=format&n=MrJbbiNG3Gqux6Hk&q=85&s=6d2bba99d3bc27d9c8309639776ec6b5" alt="Column Profile: Data Range" width="2943" height="717" data-path="public/images/how-to-guides/quality/dr.png" />

* **Data Aggregate**: A chart showing the sum of numeric column values over time.

  <img src="https://mintcdn.com/collatedocs/MrJbbiNG3Gqux6Hk/public/images/how-to-guides/quality/da.png?fit=max&auto=format&n=MrJbbiNG3Gqux6Hk&q=85&s=042dfbde216d362377ce1c7779a3beab" alt="Column Profile: Data Aggregate" width="2943" height="717" data-path="public/images/how-to-guides/quality/da.png" />

* **Data Quartiles**: A chart showing the First Quartile, Median, Inter Quartile Range, and Third Quartile to reveal how values are spread.

  <img src="https://mintcdn.com/collatedocs/MrJbbiNG3Gqux6Hk/public/images/how-to-guides/quality/dq.png?fit=max&auto=format&n=MrJbbiNG3Gqux6Hk&q=85&s=b4eddd20c8a98f6989ff4e09a39fb932" alt="Column Profile: Data Quartiles" width="2943" height="717" data-path="public/images/how-to-guides/quality/dq.png" />

* **Data Distribution**: A histogram showing how character lengths are distributed within the column.

  <img src="https://mintcdn.com/collatedocs/MrJbbiNG3Gqux6Hk/public/images/how-to-guides/quality/dd.png?fit=max&auto=format&n=MrJbbiNG3Gqux6Hk&q=85&s=7b342cfce3b495c3b15b830ab0a8f5eb" alt="Column Profile: Data Distribution" width="2943" height="909" data-path="public/images/how-to-guides/quality/dd.png" />
