Search and filter the Lake

A large tree is hard to scan. The search box finds any item by name and jumps to it, and the Filter button narrows the tree to the folders, types, datasources or deployment states you pick. Both sit in the tree panel; The Lake screen covers the rest of the workspace.

Search the tree

  1. Click the box marked Search lake..., beside Filter in the tree panel.
  2. Type what you are looking for. The result list opens as you type, and opens again when you click the box while your text is still there.
  3. Click a result to go to it. The tree expands the collapsed parents, scrolls to the item and briefly highlights it.

Results are grouped by item type: Datasources, Databases, Schemas, Tables, Columns, Workflows and Folders. Each result shows the path of its parents under its name. Search covers the whole tree, not only the rows you have expanded, and matches both the name of an item and the label shown in the tree.

Within a group, closer matches come first: an exact name, then items that start with your text, then items that contain it. The list shows at most 50 results. The count beside the box shows how many matches it found; at the limit it reads 50+ and the list ends with Showing first 50 results. Type more to narrow the list. If nothing matches, the list shows No results for followed by your text. The X in the box clears the search.

Filter the tree

  1. Click Filter, beside the search box. The pane opens next to the tree panel with the categories Folder, Type, Datasource and Deploy.
  2. Pick any combination. Every click applies at once; click a chosen option again to remove it.
  3. Click Reset to clear every filter. While a filter is on, a small Reset also appears beside Filter, so you can clear everything without opening the pane.

A number beside Filter shows how many filter categories you have set, from one to four. Each category counts once, no matter how many options you pick inside it.

CategoryWhat it lists
FolderThe folders that hold at least one datasource. Empty folders are not listed.
TypeThe source types of your datasources.
DatasourceYour datasources, narrowed by the folders and types you pick.
DeployDeployed and Not deployed; each option appears only while something in your scope is in that state.

Choices cascade. When you pick a folder, Type and Datasource choices that have nothing in it are removed; when you pick a type, datasources that no longer match are removed. If a Deploy choice stops applying, it clears itself.

The pane has a Search filters... box that narrows the options of the category you are in; when nothing matches it says No matches. A category with nothing to show says so: No folders, No types, No datasources, or No datasources match when your folder or type choices already narrow the pool.

With a Deployed or Not deployed filter on, tree actions act on tables only: Delete skips the datasources, databases, schemas and folders in your selection.

Your filters stay on while you work. They are kept for the session, so a reload does not lose them.

Questions, answered

What does the number next to Filter mean?

It counts the filter categories you have set, not the number of options inside them: with folders and datasources picked it reads 2. The number disappears when you clear every filter.

Do I need to click Apply after I pick a filter?

No. Every option you click applies at once, so the tree updates as you choose. Click Reset to clear every filter.

Why did some of my filter choices disappear?

Filter choices cascade. When you pick a folder, Type and Datasource choices that have nothing in it are removed; when you pick a type, datasources that no longer match are removed. Widen the earlier choice and pick them again if you need them.

Why are there no Deploy options?

The Deployed and Not deployed options appear only while your scope has tables in that state. If the state your filter was set to disappears, the filter clears itself.

Why is my folder not in the Folder list?

The Folder list offers only folders that hold at least one datasource. Move a datasource into the folder and it appears. See Batch edit and organise.

Does search find items inside collapsed branches?

Yes. Search covers the whole tree, not only the rows you have expanded, so a match inside a collapsed branch is still listed.

Why does search show only 50 results?

The list is capped at 50 results. At the limit, the count beside the box reads 50+ and the list ends with Showing first 50 results. Type more characters to narrow it down.

Can I search for a column?

Yes. Columns is one of the result groups. Search checks both the name of an item and the label shown in the tree, so either spelling finds it.

What happens when I click a search result?

The tree expands the collapsed parents, scrolls to the item and briefly highlights it, so you can see where it lives. See The Lake tree for how items are nested.

Are my filters still on tomorrow?

No. Filters are kept for the session, so a reload does not lose them, but a new session starts with none.

With the Deploy filter on, why does Delete remove only tables?

While a Deployed or Not deployed filter is on, tree actions act on tables only. Delete skips the datasources, databases, schemas and folders in your selection; click Reset to clear the filter and delete them.