How to use DESCRIBE DETAIL in Databricks Dashboards

[alvaromoure]

Hi all,

I am currently stuck because runing DESCRIBE DETAL in my catalog's tables return an error like:
[PARSE_SYNTAX_ERROR] Syntax error at or near 'hive_metastore'. SQLSTATE: 42601 (line 1, pos 21)

Why is this not supported in the dasboards but the same query runs as a normal SQL Query in both notebooks and SQL Queries?

[pranav_k1]

Both DESCRIBE and DESCRIBE DETAIL are supported by databricks sql
But DESCRIBE DETAIL is only supported for tables not for views
Error you are getting is due to the SQL statement you have used is not valid and hence cannot be executed
Please check your sql statement