Specifies whether the provider retrieves metadata from all available catalogs and schemas in Databricks or only from those specified in the connection.

Syntax

Connect-Databricks -QueryAllMetadata bool

Data Type

bool

Default Value

true

Remarks

When this property is set to true, the cmdlet queries metadata from all catalogs and schemas that the connection can access in Databricks.

When this property is set to false, the scope of metadata discovery is limited based on the Catalog and Database properties:

• If only Catalog is set, metadata is queried from all schemas within that catalog.
• If both Catalog and Database are set, metadata is queried only from the specified catalog and schema.
• If neither property is set, metadata is queried from the default catalog and schema.

This property is useful for optimizing connection startup time and reducing the amount of metadata retrieved from Databricks when working with large or complex environments.