07 · Tables A→ZG · Read & explore
Profile distributions & data quality
Get a statistical overview of a table - row count, nulls, distinct counts, and ranges.
profile_table returns a statistical overview of a table: row count, null
distribution, distinct counts, and value ranges. It's the fastest way to
understand unfamiliar data and to spot quality issues.
Profile
profile_table(table="eddytor.cfg_xxx.<uuid>_products")Returns, per column: nulls, distinct counts, and value ranges - plus the overall row count.
What it's good for
- Sanity-check a load - does the row count match, are nulls where you expect? (Step 1 of the post-load loop.)
- Find domain candidates - a string column with few distinct values across many rows is a good one to constrain.
- Spot anomalies - unexpected ranges, surprising null rates, runaway cardinality.
Where it fits
Use it alongside the validators when checking quality:
profile_table- the statistical picture.validate_constraints- PK / NOT NULL / CHECK.validate_domain_values- domain mismatches + typo suggestions.
Good to know
For AI-assisted quality work - summarize, detect anomalies,
find duplicates, fix nulls - Eddytor also offers AI analysis ("Magic Dust") with
your own LLM keys.