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/