profile_table
Analyze column statistics, data distributions, and sample records by profiling a table. Obtain cardinality, null counts, and top value frequencies.
Instructions
Profiles a table by analyzing column statistics, data distributions, and sample records. Returns metadata, cardinality info, null counts, and representative samples for each column.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| tableName | Yes | Name of table to profile (schema.table or table) | |
| schemaName | No | Explicit schema (defaults to 'dbo') | |
| sampleSize | No | Number of sample rows (default 100, max 1000) | |
| includeSamples | No | Return sampled rows used for profiling (default false) | |
| includeDistributions | No | Include top value frequencies (default true) | |
| topValuesLimit | No | Max distinct values per column (default 10, max 50) | |
| columnsToProfile | No | Specific columns to profile (default: all) | |
| environment | No | Optional environment name to target. |