Describe Table as JSON

Table description as JSON are available in Databricks.

When running a SQL-Warehouse or a Cluster with Runtime 16.2 or above, you can get table descriptions as JSON. This comes in very handy if you want to programmatically use parts of the table description in downstream processes. In Python, you can directly convert it to a JSON object and do some Python magic with it.

Thanks to Hubert Dudek for mentioning it, I just had to try it out.

Try it out today and tell me how you use it!

Link: https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/sql-ref-syntax-aux-describe-table