Search for workspace objects

This article describes how to search for tables, notebooks, queries, dashboards, alerts, files, folders, libraries, jobs, repos, partners, and Marketplace listings in your Databricks workspace.

Tables must be registered in Unity Catalog to appear in search results.

In workspaces that use customer-managed keys for encryption, notebook contents and query contents are not available in search.

Search by text string

To search for a text string, type the string into the search field and then press Enter. 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

You can place quotation marks around your search entry to narrow search results to only documents that contain your exact phrase.

Exact match search supports the following:

  • Basic quotation marks (for example, "spark.sql(")

  • Escaped quotation marks (for example, "spark.sql(\"select")

Exact match search doesn’t support the following:

  • With quotation marks and without quotation marks (for example, "spark.sql" partition)

  • Multiple quotation marks (for example, "spark.sql" "partition")

Limit search to a specific object type

You can also search for items by type (such as file, folder, notebooks, libraries, table, or repo) by clicking the corresponding tab in the advanced Search dialog. A text string is not required. If you leave the text field blank and then press Enter, the system searches for all objects of that type. Click a name from the list to open that item in the workspace. 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 and models in Unity Catalog-enabled workspaces

In workspaces enabled for Unity Catalog, you can search for tables and models registered in Unity Catalog. You can search on any of the following:

  • Table or model names.

  • Table or model comments.

  • Table column names.

  • Table column comments.

You can filter search results by parent catalog and database (schema) using the advanced Search dialog.

Search results don’t include:

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

    In other words, for a table or model to appear in your search results, you must have at least the SELECT privilege on that table or EXECUTE privilege on the model, the USE SCHEMA privilege on its parent schema, and the USE CATALOG privilege on its parent catalog. 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.

  • Models in the workspace model registry.

    To upgrade ML workflows to create models in Unity Catalog, see Upgrade ML workflows to target models in Unity Catalog.