Azure - Tables not showing when using Databricks search bar

[main0034]

Hi all,

I am unable to search for tables in the search bar. I can see them under Catalog and I can even see them when browsing 'Location' in the search menu.

What can be the issue here? I have tables both in the DBFS root and in a separate Storage Account. From my understanding, they are all managed by Unity Catalog.

Thanks in advance.

[Alberto_Umana]

Hi @main0034,

The issue you are experiencing with the inability to search for tables in the search bar, despite being able to see them under Catalog and when browsing 'Location' in the search menu, could be related to several factors:

1. Search Functionality Limitations: The current implementation of the catalog explorer's sidebar filter exclusively refines catalogs based on the search query. If a user has not expanded any catalogs or schema, the UI lacks essential information to filter the schema and tables within the explorer. This means that the search bar might not be able to locate tables if the catalogs or schemas have not been expanded first.
2. Unity Catalog Configuration: Ensure that Unity Catalog is properly configured and enabled for your workspace. Verify that the metastore is attached to the workspace and that the cluster has Unity Catalog supported cluster access modes (shared/single user). You can check if Unity Catalog is enabled by looking at the Data Explorer in the workspace or using the REST API.
3. Cluster and SQL Warehouse Settings: Verify that the cluster or SQL warehouse you are using supports Unity Catalog. For interactive/job clusters, ensure that the cluster shows up with shared/single user access and that the value of data_security_mode in the cluster JSON spec is not set to LEGACY_TABLE_ACL/LEGACY_SINGLE_USER_STANDARD. For SQL warehouses, check if the Unity Catalog mode is enabled in the advanced options of the warehouse details page

[main0034]

Hi and thank you for your reply.

I can see that my workspace is attached to the metastore in the admin console. I am pretty new with Databricks but everything related to Unity Catalog looks good to me.

Can you be more explicit about what you mean by "Ensure that Unity Catalog is properly configured..."?

I have used a cluster that has UC enabled for my Notebooks. Is there anything else I should be aware of related to clusters? I don't quite follow how that is related to the search.

Thanks!