Query with SHOW and Describe command not working in Databricks Dashboard

Anmol_Chauhan
New Contributor III

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.

 

 

Advika_
Community Manager
Community Manager

Hello @Anmol_Chauhan!

Dashboard Data Editor is designed for querying and working with datasets to create dashboard visualizations. However, outputs from commands like show, describe, or explain are not valid as datasets, which is why the query does not work in this editor.
For retrieving table properties or other metadata, the SQL Editor or Notebooks would be a better option, as they support such queries.

You can find more details on how datasets work in the Dashboard Data Editor here: https://docs.databricks.com/aws/en/dashboards/datasets and https://learn.microsoft.com/en-gb/azure/databricks/dashboards/datasets/