columnStats
columnStatsComputes basic statistics for a specified column: total and non-null row counts, distinct values, and minimum/maximum values. Use it to quickly assess data quality and range.
Instructions
Measure basic extremes and cardinality for one known column: total/non-null rows, distinct count and min/max. Use columnDistribution for frequent values or columnHistogram for percentiles.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| column | Yes | ||
| schema | No | ||
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | ||
| column | No | Column whose basic statistics were measured. | |
| schema | No | ||
| maxValue | No | Maximum observed non-null value for the column. | |
| minValue | No | Minimum observed non-null value for the column. | |
| totalRows | Yes | Total number of rows considered for this statistic. | |
| nonNullRows | Yes | Number of rows where the column value is not NULL. | |
| distinctValues | Yes | Estimated or exact number of distinct non-null values. |