QueryAllMetadata
Specifies whether the provider retrieves metadata from all available catalogs and schemas in Databricks or only from those specified in the connection.
Data Type
bool
Default Value
true
Remarks
When this property is set to true, the provider 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.