Global search #

Starburst Galaxy’s global search lets you locate your data entities in Galaxy.

Search overview #

Use global search to locate any data object anywhere throughout your Starburst Galaxy account. You can search for the names of catalogs, schemas, tables, views, columns, or data products. Global search parses Galaxy’s cached description of your account, which means it does not require any cluster to be enabled or running.

Global search explicitly does not match against words in the metadata of the search targets, which is the metadata you see in levels of the catalog explorer. For example, global search does not match text in the Description, Tags, Contacts, or Owner fields of entity metadata.

The search type is a case-insensitive anchored search that matches entity names by trying to match the first characters of the search term to the first characters of various target strings. As a result, to locate an entity named token, the search string tok matches, but search string ken does not.

Search globally #

To begin searching:

1. Click the magnifying glass icon located in the banner of Starburst Galaxy to open the search field. Alternatively, you can open the search field with the / key:

   

2. In the search field, enter your search term. A truncated preview of the results is shown.
3. Click the matching entity to navigate directly to that entity in the catalog explorer, or click View all results to open the Search results pane.

Search results pane #

In the search results pane, narrow the scope of the search results using the Filter pane. Select one or more filter options to restrict the search results to match selected categories.

For example, to see only views related to your search term, select View in the Asset type filter category. The results are returned in the default grid mode:

To use list mode to show only the entity names matching your search term and filters, click the button:

Available filter categories include:

• Asset type: restrict the current search results to match names of catalogs, schemas, tables, views, columns, and/or data products.
• Catalog: restrict the current search results to match schema, table, view, or column names in specific catalogs.
• Tags: restrict the current search results to match entities that have one or more specified tag names.
• Contact: restrict the current search results to match usernames designated as contacts for the entity.
• Owner: restrict the current search results to match roles designated as entity owners.

Click the pencil icon next to the search term to edit the search query or start a new search.

Use the drop-down Order by menu to sort results by relevance, name, or description.

Click the Results per page drop-down to adjust the number of results you see per page to 5, 10, 25, or more if you have that many results.

Search in the query editor #

Search for an entity name in the cluster explorer pane of the query editor.

To search your data:

1. If the cluster explorer pane is not visible, click the icon to open the pane.

2. Use the Search data field denoted by the magnifying glass icon at the top of the cluster explorer pane.

3. Type your search term. As you type, entities that match what you are typing are revealed and highlighted in yellow:

In addition to providing search in the cluster explorer, Starburst Galaxy’s implementation of global search provides auto-completion for entity names when typing in the query editor pane.

See Query editor > Auto-completion for further information on auto-completion.

Search in the catalog explorer #

Search by entity name in the catalog explorer.

To search your data:

1. If the catalog explorer pane is not visible, click the icon to open the pane.

2. Use the Search data field denoted by the magnifying glass icon at the top of the catalog explorer pane.

3. Type your search term. As you type, entities that match what you are typing are revealed and highlighted in yellow: