profile_dataset
Profile every column of a Socrata dataset: compute null rates, distinct counts, min/max for dates and numbers, and top 10 values for text columns, all server-side without downloading.
Instructions
Profile every column: null rate, distinct count, min/max, top values.
Computed portal-side via aggregate SoQL — the dataset is never downloaded. Dates and numbers get min/max (numbers also avg); low-cardinality text columns get their top 10 values with counts.
Args: domain: Portal hostname, e.g. "data.seattle.gov". dataset_id: Socrata 4x4 id, e.g. "tazs-3rd5".
Returns: {row_count, columns: [{field_name, type, null_rate, non_null_count, distinct_count, min?, max?, avg?, top_values?, error?}], notes}.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| domain | Yes | ||
| dataset_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||