v.21.11New Features

Allow Subcolumns in DESCRIBE Query Results

Allow to include subcolumns of table columns into DESCRIBE query result (can be enabled by setting describe_include_subcolumns). #28905 (Anton Popov).
Adds the ability to include subcolumns of table columns in the DESCRIBE query output by enabling the describe_include_subcolumns setting.

Why it matters

This feature improves the detail and clarity of DESCRIBE query results by showing subcolumns, which helps users better understand the structure of nested or complex table columns.

How to use it

Enable the feature by setting describe_include_subcolumns to 1 or true before running the DESCRIBE query.

Example:
SET describe_include_subcolumns = 1;
DESCRIBE TABLE your_table;