list_columns
Retrieves column names and metadata for a ClickHouse table or view using system.columns. Specify table name with optional database and profile.
Instructions
[ClickHouse] List columns for a table or view.
Rows from system.columns for the resolved database and table.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table or view name, or database.table. Src: tables. | |
| profile | No | Profile name; uses default profile when omitted. Src: profiles. | |
| database | No | Database when table is unqualified; ignored if table contains a dot. Client default when omitted. Src: databases. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | Row values aligned with the columns list. | |
| columns | Yes | Ordered list of column names. Each row aligns with these names by index. |