SHOW DATABASES command: Includes mountless databases from organization listings (Pending)

Attention

This behavior change is in the 2026_07 bundle.

For the current status of the bundle, refer to Bundle history.

This behavior change is for accounts that use organization listings and have the ENABLE_SHOW_MOUNTLESS_LISTINGS_IN_SHOW_DATABASES parameter enabled. It’s intended to unblock customers who consume mountless listings through third-party tools, such as Power BI, that can’t be modified to look beyond SHOW DATABASES.

Before the change:

SHOW DATABASES and SHOW TERSE DATABASES return only the local databases in the current account.

After the change:

When the 2026_07 behavior change bundle is enabled in your account and ENABLE_SHOW_MOUNTLESS_LISTINGS_IN_SHOW_DATABASES is set to TRUE, SHOW DATABASES and SHOW TERSE DATABASES list local databases first, followed by mountless databases derived from organization listings. An organization listing is included only if it’s:

  • Mountless accessible.
  • Replicated to the caller’s deployment.
  • Sharing a database, rather than an application.

Discovery-only listings, and listings not yet replicated to the caller’s deployment, aren’t included. If the row limit for SHOW DATABASES is reached, mountless databases at the end of the list are truncated first.

If your account doesn’t use organization listings, this change has no effect on query results or performance, because there are no organization listings to scan.

Ref: 2410