topic Re: How to use DESCRIBE DETAIL in Databricks Dashboards in Warehousing & Analytics

How to use DESCRIBE DETAIL in Databricks Dashboards

alvaromoure — Wed, 06 Nov 2024 10:21:55 GMT

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?

Re: How to use DESCRIBE DETAIL in Databricks Dashboards

pranav_k1 — Wed, 06 Nov 2024 10:29:41 GMT

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