distinct_values
List the distinct values of ONE filterable column of a topic — the fast way to learn valid filter values before query_dataset, especially for FREE categoricals and FK codes (district_code/school_code/county_fips/demographic) that carry no enum in describe_dataset (a wrong guess otherwise returns an empty page with no error). column must be a filterable column (see describe_dataset's filters). Optional prefix does a case-insensitive starts-with filter; limit caps results (default 50). Enum-bearing columns return their contract enum directly; others run a capped SELECT DISTINCT over the gold data. truncated flags when the list is capped.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| topic | Yes | ||
| column | Yes | ||
| detail | No | ||
| prefix | No | ||
| main_topic | No | education |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||