Query with SHOW and Describe command not working in Databricks Dashboard

Anmol_Chauhan
New Contributor II

Hi Folks,

I am trying to retrieve table properties of delta table in Databricks dashboard data editor but getting error message.

It seems like describe and show command not working with dashboard editor as Query is working fine in sql editor and notebooks.

Please refer below query and screenshot:

Query: 

show tblproperties catalog.schema.tab_test;
Error:
[PARSE_SYNTAX_ERROR] Syntax error at or near 'tblproperties'. SQLSTATE: 42601 (line 1, pos 20) == SQL 

Anmol_Chauhan_1-1739806218544.png

Please help me to resolve this issue.