ALL CATALOGS in SHOW SCHEMAS

creativeIndex — Wed, 04 Jun 2025 04:39:37 GMT

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!

Re: ALL CATALOGS in SHOW SCHEMAS

Walter_C — Wed, 04 Jun 2025 13:00:46 GMT

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

topic Re: ALL CATALOGS in SHOW SCHEMAS in Data Governance

ALL CATALOGS in SHOW SCHEMAS

Re: ALL CATALOGS in SHOW SCHEMAS