Database Tree

Data Catalog

The Data Catalog shows all the tables and fields in the current project schema.  

The number of records in the table is displayed next to the table name:

Low cardinality Fields (less than 256 discrete values) will include a list of unique values:

Wide Tables

Tables with a large number of fields (many hundreds) will not display their field list in the Database Tree.   To work with tables that have a high number of fields, use the Database List.

Context Panel

Selecting a Field will show a profile in the Context Panel. If there are less than 256 discrete values, a bar chart will be available.   If there are less than 24 discrete values, a pie-chart will also be available.   The counts for each field value are displayed in a searchable, sortable, selectable grid.

Drag To Hotbar

• Tables are a dataset source for the whole table - drag a table into the HotBar to select all records in the table 
• Fields are a dataset source - drag a field into the HotBar to bring up a Field Query Box
• Dataset fields can be dragged directly into the HotBar - drag a Dataset field and drop into the HotBar to select all records where Dataset Field = 1

Drag To Workspace

• Drag a table into the Workspace window and choose DataView to open a DataSet ScratchTab for the table - this will display the underlying records.    
  • Drag Fields onto the grid to add columns to the view

• Drag a field into the Workspace window and choose which action to take.  The available actions will depend on the type of field:

Drag table onto the Main Tab Bar 

• display as a dataset
• display as a dataview
• get the quick audit details of field in the table

Drag field onto the Main Tab Bar 

• profile
  • index profile
  • open a dataset with Field Query Box opened
  • open a dataview of the whole table with selected field in it's template
  • open a Statistics Report for that field (if applicable)

Dragging a field between two joined tables will popup an option to copy up/down than field.

Drag To Another Database Object

It is possible to drag and drop fields and tables on top of each other.   

Right-Click Menus

Right-clicking an item brings up the Context Menu for that item:

See Database Right-Click for more information.

Micro-Toolbar

The tree view's micro-toolbar  allows switching between tree or list view and filterer and sorting the contents of either

Dragging Within The Tree

Tip: When dragging from a field to a table in a large database, it may be easier to open a new Entity Selector from the tools menu and use that as a drag target.

Filtering The View

Open and close the filter box by clicking on the filter icon in the micro-toolbar.

The combo box allows filtering by field data type, the textbox by wildcard non case-sensitive text.

The filtered tree will display the identified fields, and all tables.

See Also

• Default Table Order