Pick tables in the resource picker

Press Alt+Q or use Open Popups in the sidebar to open the resource picker. The picker finds a table and opens it, or hands one or more tables back to the screen that opened it. This page covers the picker's Warehouse tables column; Open Popups covers the window as a whole.

Read the Warehouse tables column

The Warehouse tables column lists your Warehouse tables as rows, and it works the same wherever the picker appears.

• Each group header has a chevron, the group name and the number of tables in the group.
• Each row starts with a small mark for the table's type. Hover the mark to read the type's name.
• Click a group header to open or close its group. Groups start closed.
• Tables are ordered A to Z by name, ignoring case, with numbers in natural order, so table_2 comes before table_10.

Group by source or by model

The toggle in the column header switches how the list is grouped:

• Sources groups the tables by type, in the Warehouse's own type order. A type the column does not recognise trails after the known types, under Unknown.
• Models groups the tables by logical model, A to Z. A table that belongs to several logical models appears under each of them, and tables with no logical model sit last, under Ungrouped Tables.

Your choice is one shared preference: set Models here, and the picker opens on Models on every screen that uses it. It is remembered in this browser between visits.

Search the list

Type in the picker's search box to narrow the column. While a search is active, every group shows as open, so matches appear without expanding anything; clear the search, and the groups you opened yourself come back.

• If nothing matches, the column shows "No Warehouse tables match your search".
• If there is nothing to list, it shows "No Warehouse tables".

Open a table or select tables

What a click does depends on the mode the screen opened the picker in:

• In the standard Alt+Q picker, clicking a row opens that table's editor over the page, and the picker closes. Rows carry a small open hint.
• When a screen asks you to pick one table, the row you pick stays highlighted with a check mark, and the open hint is hidden.
• When a screen asks you to select several, rows carry check marks. Select tables one by one, or click a group's checkbox to select every table in it; the group opens so you can see what was selected. The column header counts the selected tables against the total.

Some screens limit how many tables you can select:

• A table at the limit keeps the selection it already carries, but it ignores further clicks.
• A group's checkbox greys out when every table still unselected in that group is at the limit.

What the row marks say

• The mark at the start of a row shows the table's type. Hover it to read the type name; when the picker cannot name the type, the tooltip reads Warehouse table and the mark falls back to the Dimension icon.
• In Models, rows also show the table's type as a label, so you can tell a fact from a view inside one logical model.

Questions, answered

How do I switch the Warehouse list between table types and logical models?

Click Sources or Models in the Warehouse tables column header. Sources is the default, and the picker opens on whichever you chose last.

Does my Sources or Models choice apply to other pickers?

Yes. The choice is one shared preference for every screen that opens the picker, and it is remembered in this browser. You only set it once.

What does the number next to a group name mean?

The number of tables in that group.

What does the half-filled checkbox on a group mean?

Some of its tables are selected, but not all. The group checkbox has three states: unchecked when none of its tables are selected, checked when all are, and half-filled when only some are.

Why is a group checkbox greyed out?

Every table in that group that is still unselected has reached the selection limit for the current screen, so there is nothing left to select.

Why do all the groups look open while I search?

The search opens every group for you, so matches are visible without expanding anything. When you clear the search, the groups you opened yourself come back.

Why is a table listed under Unknown?

Its type is not one of the known kinds (dictionary, dimension, fact, static table or view), so it groups under Unknown. It still opens like any other table, and its mark falls back to the Dimension icon.

Does the picker close when I open a table?

Yes, in the standard Alt+Q picker. Clicking a table opens its editor over the page, and the picker closes.

Why do the rows lose their open hint when I am selecting tables?

While a screen is collecting your selection, a click selects rather than opens, so the open hint is hidden by design. Open the table from the Alt+Q picker instead.

Do Sources and Models keep separate open groups?

Yes. Each grouping keeps its own open groups while you browse, so switching between Sources and Models leaves the other view as you set it.

What order are the tables listed in?

A to Z by name, ignoring case, with numbers in natural order, so table_2 comes before table_10. In Sources, groups follow the Warehouse type order; in Models, logical models are A to Z, with Ungrouped Tables last.

Why does a group open when I click its checkbox?

So you can see exactly which tables the click selected.