Query with SHOW and Describe command not working in Databricks Dashboard

Anmol_Chauhan — Mon, 17 Feb 2025 15:34:32 GMT

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

Please help me to resolve this issue.

Re: Query with SHOW and Describe command not working in Databricks Dashboard

Advika_ — Mon, 24 Feb 2025 08:40:24 GMT

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/

topic Query with SHOW and Describe command not working in Databricks Dashboard in Data Engineering

Query with SHOW and Describe command not working in Databricks Dashboard

Re: Query with SHOW and Describe command not working in Databricks Dashboard