Clean up the Object Browser Using Database Grouping and Entity Filters

Perhaps you want to block out the “noise” from your Aginity Workbench to focus your work on a select group of databases or even a select group of schemas or tables?  The database grouping and entity filter functionality of Workbench allows a user to accomplish these objectives.  See below for examples.  

Although the below examples are for Aginity Workbench for Netezza, this functionality applies to other Wokrbench platforms as well.

 Use Case 1:

There are many databases on the server, but I want to easily find the relevant databases in my UI.  My relevant databases are:

  • BWEISSLER_BASE
  • BWEISSLER_DB
  • BWEISSLER_DB_V21
  • BWEISSLER_META
  • BWEISSLER_SANDBOX
  • SYSTEM

Use Case 2:

I want to display only the tables that start with ‘FB%’ inside any database in my object browser to assist me doing my fantasy baseball analysis.

Step 1:

Create a database grouping called “My Databases”.  This is a top-level grouping that can contain many sub-groups.

 

 

The database sub-groups “Data” and “System” will now show in the UI as separate nodes. All other databases you have access to will still be included in the object browser under the “Uncategorized” node.

Database_Grouping_and_Entity_Filter_Step_1.2.png 

Step 2:

Create an Entity Filter "Fantasy Baseball" to only display objects with a name starting with ‘FB%’

Database_Grouping_and_Entity_Filter_Step_2.2.png

 

Step 3:

Display the database grouping defined in the “My Databases” database grouping.

Database_Grouping_and_Entity_Filter_Step_3.3.png

 

Step 4:

Filter the objects defined in the “Fantasy Baseball” filter in all databases.

Database_Grouping_and_Entity_Filter_Step_4.2.png

 

 

Database_Grouping_and_Entity_Filter_Final_Result.2.png

 

Please note it is not necessary to create database groupings in order to implement the entity filters.  Each feature can be used independently.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk