DESCRIBE Statement#

The DESCRIBE statement shows the schema of a table or the execution plan of a query.

DESCRIBE TABLE#

Shows the schema (column names and data types) of a table.

Syntax#

1

DESCRIBE [TABLE] <table_name>

Examples#

Describe the schema of table T.

1

DESCRIBE T;

Describe the schema with the optional TABLE keyword.

1

DESCRIBE TABLE T;

Describe a table in a specific catalog and namespace.

1

DESCRIBE my_catalog.my_namespace.my_table;

Output#

Returns a DataFrame with columns:

DESCRIBE SELECT#

Shows the query execution plan for a SELECT statement.

Syntax#

1

DESCRIBE <select_statement>

Examples#

Describe the execution plan for a simple query.

1

DESCRIBE SELECT * FROM T;

Describe the execution plan for a query with joins.

1

DESCRIBE SELECT a.*, b.name FROM T a JOIN S b ON a.id = b.id;