Profile column data
get_data_profileProfiles table or view columns to reveal null ratios, distinct counts, minimum/maximum values, and top values, so you can understand data distribution without paging through rows.
Instructions
Profiles the columns of one table or view: null ratio, distinct count, minimum, maximum and most frequent values. Use it to learn how data is distributed without paging through rows with query_table. It reads actual row values and scans the table, so on a large table it can take a while; limit it to the columns you need.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name, bare, with no schema prefix. | |
| schema | No | Table schema. Empty means dbo. Example: 'Feeder' | |
| columns | No | Columns to profile as ONE comma-separated string, not a JSON array. Example: 'Source, Name'. Empty profiles every column. | |
| database | Yes | Name of the database as registered in the configuration. | |
| top_values | No | Top frequent values to return per column (default 5). |