View Dynamic Table Structure (DESC DYNAMIC TABLE)

Description

The DESC command is used to view the structural information of a Dynamic Table. By default, it returns only column names, data types, and comments. Adding the EXTENDED keyword reveals the full table metadata, including refresh configuration, source tables, query definitions, and more.

Syntax

DESC [TABLE] [EXTENDED] <dt_name>; -- or DESCRIBE [TABLE] [EXTENDED] <dt_name>;

Parameter Description

Parameter	Description
`DESC` / `DESCRIBE`	Both are equivalent and interchangeable
`TABLE`	Optional keyword
`EXTENDED`	Optional. When specified, returns full table metadata
`dt_name`	The name of the dynamic table, which may include a schema prefix

Usage Examples

Example 1: View column structure of a dynamic table

DESC dt_agg; +-------------+-----------+---------+ | column_name | data_type | comment | +-------------+-----------+---------+ | j | int | NULL | | cnt | bigint | NULL | +-------------+-----------+---------+

Example 2: View full information of a dynamic table

Key fields returned in EXTENDED mode:

Field	Description
`type`	Object type; dynamic tables display `DYNAMIC TABLE`
`view_text`	The query definition of the dynamic table (formatted)
`view_original_text`	The original query definition
`source_tables`	List of source tables
`refresh_type`	Refresh type (`on schedule` indicates scheduled refresh)
`refresh_interval_second`	Refresh interval in seconds
`refresh_vcluster`	The compute cluster used for refreshes
`refresh_start_time`	The start time for refreshes
`format`	Storage format (typically `PARQUET`)
`statistics`	Row count and byte count statistics

Notes

Without EXTENDED, only column structure is returned (column name, data type, comment).
With EXTENDED, full metadata is returned, including refresh configuration, source tables, query definitions, etc.
Dynamic tables do not support DESC TABLE ... HISTORY syntax. Use DESC HISTORY <dt_name> to view historical versions.