Galaxy view

Use Pentaho Data Catalog

Version
10.1.x
Audience
anonymous
Part Number
MK-95PDC000-02

You can use the Galaxy view feature to quickly view the structure of your data and its details. This feature is especially useful when you want to view information that is not easily visualized using the navigation tree in the Data Canvas. When you open the data in Galaxy view, you can see the relationships in your data from a bird's eye view, and drill down into the data for specific details.

When using a keyword search in Galaxy view, you can limit the scope of the returned data using filters. For example, an information security officer may want to find all the databases that contain credit card information. In Galaxy view, they can search for “credit” while setting the filter to Columns and locate key columns of credit card information across multiple databases.

You can access Galaxy View from Data Canvas or from Business Glossary.
  • To access Galaxy view from the Data Canvas, select a folder or other resource, click Actions and select View Galaxy.
    View Galaxy
  • To access Galaxy View from the Business Glossary page, select a glossary item, that is a domain, category, or term, click Actions and select View Galaxy.
    View Galaxy in Business Glossary
Here are the key tasks you can perform in Galaxy view:
Search
Enter a keyword and select Search to find specific information within the resources. For example, enter "address" to just show those sources, tables, and columns containing address information.
View Details
Right-click on a selected data resource or column in Galaxy view and select View Details. The details panel appears. Depending on your selection, you can view different information, such as properties, tags, and custom properties. Additionally, you can also view and add business terms to the resource.
View Items
Right-click on a data resource in Galaxy view and select View Items. You can view the associated parent and child data assets in a tree view.
Select and Select Tree
To select a single data resource, right-click on a data resource in Galaxy view and click Select. Additionally, you can select associated data resources by clicking Select Tree. When an item is selected, you can right-click and Deselect the item
Focus
Right-click on a selected data resource or table and select Focus. Only the resource and its children appear. Continue to drill down using the Focus option as needed or select Leave Focus to return to the full view.
Filter
If you want to reduce the amount of data displayed, you can filter the level of detail in your view by columns or tables. In Galaxy view, click Filters to open the Filters dialog box and select one or more of the following options.
Level of Detail
By default, Galaxy view shows down to the table level as a reduced set of data. Click Columns and apply to have a detailed view down to the column level.
Show Relationships
Helps to limit the results in the view with the data resources that are Declared Foreign Key and Discovered Foreign Key.
Show only Related Items
When the Show Relationships is active, you can choose a threshold number to refine the results further.
Show only Tagged Items
Select this check box to limit the results in the view with the data resources that have associated tags. You can further refine your view by selecting specific tags.
Show only Items with Business Terms
To further limit the results in the view, select this check box. You can further refine your view by selecting specific business terms.
Show Data Elements
You can also choose to show the data elements by selecting this check box.
Reset
Discard your filters.
Apply
See Galaxy view with your applied filters.