Query with SHOW and Describe command not working in Databricks Dashboard
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-17-2025 07:34 AM
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.