Search Databricks

This article describes how to search for notebooks, queries, dashboards, alerts, files, folders, libraries, and repos in the Databricks workspace.

It also describes how to search for tables registered in Unity Catalog.

Note

The search behavior described in this section is not supported on workspaces that use customer-managed keys for encryption. In those workspaces, you can click Search Icon Search in the sidebar and type a search string in the Search Workspace field. As you type, objects whose name contains the search string are listed. Click a name from the list to open that item in the workspace.

Access the search dialog

To search the workspace for an object, click Search Icon Search in the sidebar. The Search dialog appears.

search dialog

You can search by text string, by object type, or both. After you enter your search criteria and press Enter, the system searches the names of all queries, dashboards, alerts, files, folders, notebooks, libraries, and repos in the workspace that you have access to. If your workspace is enabled for Unity Catalog, it also searches table names, table comments, column names, and column comments.

When you click an item in the search results, the item automatically opens in the appropriate persona-based environment. For example, when you click a query, it opens in Databricks SQL.

Search by text string

You can search for a text string by typing it into the search field. The system searches the names of all objects in the workspace that you have access to. It also searches text in notebook commands, but not in non-notebook files.

search for text

Limit search to a specific object type

To limit your search to a specific type of item (such as notebooks only), click the corresponding tab. If you leave the text field blank, the system searches for all objects of that type. You can also use the dropdown menus to search for items by owner or by the last modified date.

search by item type

Search tables in Unity Catalog-enabled workspaces

In workspaces enabled for Unity Catalog, you can search for tables registered in Unity Catalog. You can search on table names, table comments, column names, and column comments. You can filter search results by parent catalog and database (schema).

Search results don’t include:

  • Tables that you don’t have permission to see.

    In other words, for a table to appear in your search results, you must have the SELECT privilege on that table and USAGE privileges on its parent schema and parent catalog. Account admins and metastore admins have those privileges by default. All other users must be granted those privileges. See Unity Catalog privileges and securable objects.

  • Tables in the legacy Hive metastore (that is, in the hive_metastore catalog).

    To upgrade these tables to Unity Catalog and make them available for search, follow the instructions in Upgrade tables and views to Unity Catalog.

You can also search for tables using Data Explorer.