Category: Analytics
Node id: estate-profile
Maturity: beta
Risk tier: none
Compute per-column statistics from sampled rows: null ratio, distinct count, min/max, percentiles, dominant value shapes and placeholder detection. Emits statistics only — no sampled value is ever carried out.
What it does
- Kind inference independent of the source's declared type
- Abstracted value shapes instead of values
- Placeholder detection (1900-01-01, 9999, UNKNOWN)
- Sampled versus exact recorded on every result
Use cases
- Profile a hospital table before proposing a FHIR mapping
- Detect that a birth-date column carries three different formats
- Find columns that are mostly null before relying on them
Runtime
Output ports
Settings
Basic
Advanced
Errors
Runtime notes
- Profiles the rows on its input port; it does not read the source again, so it adds no load to the system being catalogued.
- Emits statistics and abstracted shapes only — no sampled value leaves this node, which is what makes the output safe to store and to send to a model.
- Kind is inferred from the values, not from the source's declared type: a HIS that types everything as VARCHAR tells you nothing.
- A two-valued 0/1 column is reported as boolean, because calling it numeric produces a mean that means nothing.
- Every result records whether it came from a sample or the whole column, so a sampled figure is never read as a census.
See Build any workflow for how to put nodes together and Ports, types and data flow for how port types connect.