Apply filters and aggregation transformations from RDBMS widget

Prior to 2022.09 build, the user applied Filters and Aggregations transformations independently but now the user can use these transformations embedded in RDBMS widget to reduce data ingestion and execution time. This enhancement currently works only with RDBMS widget in FDR, validation and QC.

To learn more, let us walk through the below procedure:

• Click the ‘Query Studio’ module.
• Hover on the ‘Query Builder’ snippet.
• Click the ‘Query Chain’ option.

• The user is navigated to the new Query Chain session page.
• From the ‘Data Source’ tab, let’s drag and drop an ‘RDBMS Table’ icon onto Query Chain create and edit page.

Note: All other Data Source icons including ‘RDBMS Table’ gets disabled as the user drags it onto Query Chain session page.

• Double tap the ‘Read data from Table’ widget.

• A ‘Read data from table’ pop-up window is displayed.
• Let’s select ‘PostgreSQL’ from ‘Database Type’ drop-down list and ‘Postgre SQL Northwind-QA’ from ‘Connection Name’ drop-down list.
• Click the ‘Navigator’ button.

• A ‘Navigator’ slide screen is displayed on the right side of the page.
• Let’s select the ‘orders’ table from the ‘Public’ schema.

• Click the ‘order’ table to pick the table.
• Click the ‘Filters’ icon which is a new enhancement.

• A ‘Filter’ pop-up window is displayed.

• Select ‘employeeid’ from the ‘Available Fields’ drop-down list, ‘Equals to’ from the ‘Available Operations’ drop-down list, and ‘input’ as ‘4’.

Note: The ‘Expression’ field is updated accordingly.

• Click the ‘Apply Filter’ button.

• An ‘Aggregation’ column is also added and the user can add different aggregation functions such as AVG, COUNT, FIRST, LAST, MIN, MAX, and SUM as per the requirement.
• Click the ‘Select’ button.

• This action saves the ‘RDBMS table’ widget data by closing it.
• The user is navigated to the Query Chain session page.
• Click the ‘Output’ tab.

• Let’s drag and drop an ‘RD Output’ icon.
• Double tap the ‘RD Output’ widget.

• An ‘RD Output’ pop-up window is displayed.
• Click the ‘Select’ button.

• This action closes the ‘RD Output’ widget data by closing it.
• Click the ‘Execute Now’ button.

• A green color tick mark indicates the Query Chain is executed successfully.
• A monitor mode is enabled.
• Let’s click on the ‘RD Output’ count icon (156).

• This action navigates the user to the ‘Results’ tab.