ch_table_schema
Retrieve comprehensive table metadata including columns, engine, keys, partitions, and sample data to understand table structure before writing queries.
Instructions
Get comprehensive table metadata: columns, engine, keys, partitions, and sample data.
Returns column types, partition/sorting/primary keys, TTL settings, row counts, disk usage, partition breakdown, and 5 sample rows. Essential for understanding table structure before writing queries.
Args: table: Table name database: Database name (default: cdc_pipeline)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| database | No | cdc_pipeline |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |