# Data Profiling

> Counting what is really in a table: blanks, values and ranges. It comes before checks.

**Field:** Data Engineering  
**Category:** Governance & Quality  
**Also known as:** Data Profile, Column Profiling

## Think of it like

It is like a check-up at the doctor. First you get the facts, then you decide.

## Definition

Data profiling means looking at data to learn what is really in it. A profile counts the rows, the empty cells and the different values in each column. It shows the smallest, the largest and the most common values. You do it before you trust a new table or write checks for it. A profile describes the data. It does not judge it.

## Example

Jack profiles a new customer table of 10,000 rows. 312 emails are blank, and one fake email shows up 240 times. He writes two quality checks from what he found.

## Example code

```sql
SELECT COUNT(*), COUNT(email), COUNT(DISTINCT email)
FROM customers;
-- 10000 | 9688 | 9410
```

Rows, filled emails and different emails, in one query. So 312 emails are blank.

## Why it matters

Checks written without a profile guess at the data. A profile shows the real problems worth a check.

## Common mistake

Trusting an old profile forever. Data changes, so run it again when the source does.

## Three principles

- **Measure first.** Count before you judge.
- **Every column.** Blanks, values, ranges and top values.
- **Feeds the checks.** Each surprise becomes a quality rule.

## Related terms

- [Data Quality Check](https://learn.benibix.com/term/data/data-quality-check)
- [Data Quality](https://learn.benibix.com/term/data/data-quality)
- [Data Completeness](https://learn.benibix.com/term/data/data-completeness)
- [Data Uniqueness](https://learn.benibix.com/term/data/data-uniqueness)
- [Data Reconciliation](https://learn.benibix.com/term/data/data-reconciliation)

## Told apart from

- [Data Profiling vs Data Quality Check](https://learn.benibix.com/compare/data-profiling-vs-data-quality-check): People think profiling data is the same as testing it. A profile only counts what is there: blanks, values and ranges. It passes no judgment. A quality check tests a rule, like no blank emails, and fails when the rule breaks. You profile first to learn the data. Then you write checks for the problems you found.

![On the left, a profile card for an email column: 10,000 rows, 312 empty, 9,410 different values, and a highlighted row where test@example.com appears 240 times. On the right, a shop database with 1,204 orders and a warehouse with 1,192, and a highlighted box: 12 orders missing.](https://learn.benibix.com/diagrams/dat2-profile-reconcile.svg)

---

Source: https://learn.benibix.com/term/data/data-profiling
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-18
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
