ALL CATALOGS in SHOW SCHEMAS

[creativeIndex]

Hi there,

I was checking though the Databricks Runtime 17.0 features while testing:

• Support ALL CATALOGS in SHOW SCHEMAS

I faced below issues, is that anticipated or an issue which needs to be fixed?

This is how it was before Runtime 17.0 👆

👆 I was expecting bronze and other schema starting with bron.

👆 I was expecting  |schema | catalog name|, 2 column in the output.

👆 Also above 2 commands are running into error.
---------------------------------------------------------------------------------------------------------------------------------------

According to the release note 

The SHOW SCHEMAS syntax is updated to accept the following syntax:

SHOW SCHEMAS [ { FROM | IN } { catalog_name | ALL CATALOGS } ] [ [ LIKE ] pattern ]

⁉️ Please let me know in case I am doing something wrong with the syntax or understanding.

Thanks!

[Walter_C]

I was able to reproduce same issue, I am working with the team, as this DBR is in Beta version we might see some changes on the behavior, so I will confirm if anything has changed around this topic