SHOW PARTITIONS not supported

Pat
Esteemed Contributor

Error in SQL statement: AnalysisException: SHOW PARTITIONS is not supported in Unity Catalog;

What happened with the SHOW PARTITIONS command?

Is this information available anywhere in the documentation?

If I go to Databricks SQL documentation there is no info this doesn't work with Unity Catalog:

https://docs.databricks.com/sql/language-manual/sql-ref-syntax-aux-show-partitions.html

I can of course do select distinct, but it's not what I've expected :). Yet another limitation with Unity Catalog.